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