View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
GJones GJones is offline
external usenet poster
 
Posts: 132
Default 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.
.