Identify rows to delete from datatype

[Hru48]

Hey,

I have a large spreadsheet and I need help with identifying which rows start with a text field so I can delete them - while not deleting the rows which start with a numeric format.

For example:

Col1 Col2 Col3
row 1 - 222 hhh 777
row 2 - abc jjj jjjj
row 3 - 333 kkk kkk


So, I would need row 2 (above) deleted but I need to retain rows 1 and 3.

The text is different every time, is there a way to search for datatypes?

Thanks

[ChrisMattock]

This Macro should delete all the rows where the first cell is not a number.

Please Login or Register  to view this content.

EDIT: For clarification the above macro starts in cell A1 and goes down checking each row until it gets to an empty cell (I assume this will be then end of your data) when it will stop. Let me know if this works for you or any problems you have.