ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Delete rows with text and blanks in column A (https://www.excelbanter.com/excel-programming/283035-delete-rows-text-blanks-column.html)

GJones

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.
.



All times are GMT +1. The time now is 01:28 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com