hi everyone.
I need to clean up my long data in column A.
The word "DIM" STARTS the next set of data downwards AND BEFORE IT is a Number.
eg.
DIM
2236.2
DIM
Vlogger
DIM. etc etc
so I need to delete Rows just before DIM in instances where IT IS NOT A VALUE. Eg above, Delete Vlogger Row since its not a number.
the column A is long down..
Thanks
I need to clean up my long data in column A.
The word "DIM" STARTS the next set of data downwards AND BEFORE IT is a Number.
eg.
DIM
2236.2
DIM
Vlogger
DIM. etc etc
so I need to delete Rows just before DIM in instances where IT IS NOT A VALUE. Eg above, Delete Vlogger Row since its not a number.
the column A is long down..
Thanks