Delete rows with text and blanks in column A
Select and sort all the data by column A Descending. then
go to the bottom and delete all the columns.
-----Original Message-----
I want to delete all rows that does not start with number
0-9 in column A.
Column A has some entries that are blank or contains text
and I want to get rid of them:
0102
text
0203
should be:
0102
0203
Of course I want to keep other columns (B and C) if A has
number.
Thanks, Oleksandr.
.
|