Delete Row if cell contains text

[Borborb]

I have found several difference renditions close to what I am trying to do but it isn't working, so I figured it was time to ask.

I have a text file that I am importing into Excel. It then has approximately 100,000 lines and much of it is useless, and needs to be reduced. I use import manager to eliminate the columns to 2.

There is a variety of data that needs to be deleted.
1. I search by blank cells in A and delete row
2. I search by blank cells in B and delete row
3. I have to CTRL+F ALL the following (This is the beginning of various entries, essentially add * to all)

• Ac
• No
• Inv
• Esc
• To
• Rep
• Ban

In reality, I need to delete every row where the value of the cell in A is not a number. The issue I have found with record macro, it doesn't like CTRL+F.

All said and done, if I manually clean this up, I'm left with about 11k lines.

I have attempted several options I have found on this site, and others, and keep coming up short. Any help would be greatly appreciated!

 

[My Aswer Is This]

My script in Post #7 deletes the empty rows also

This did exactly what I needed, thank you. I think the biggest problem was searching Google. It was rather hard to articulate what I was trying to accomplish, but learned another aspect of an already useful tool that I use, the advanced search.

While the macros way still work, this eliminates everything but the blank rows, which I can then filter out in 1 more step.

This is definitely the quickest and simplest solution!