I have data set, in which some coulums have real measured values and some column have reference values .
I want to delete column with reference values,
I can simpliy select and delete them. Problem is I have around 2300 excel files, and every file has same structure for example coloumn A,F,G,K,P,Q,AA,AX are measured value and D,H,R,T,AS are reference values.
It there any simple way ,in which i can delete them ore quickly rather than selecting each column in each file .