Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Delete rows with specific text | New Users to Excel | |||
How to Delete entire rows by selecting different text in column A | Excel Discussion (Misc queries) | |||
Delete rows with certain text | Excel Worksheet Functions | |||
Delete all rows where Column A contains Text | Excel Worksheet Functions | |||
delete empty rows between rows with text | Excel Discussion (Misc queries) |