Delete Words Not Numbers

E

evoxfan

I have a column with blanks, text, and numbers.

I want to delete the text and keep all numbers.

What is the easiest way to do this?
 
R

Ron de Bruin

Select the column
F5>Special
Constants
Uncheck all under Formulas except Text
OK

You can no delete the cells or complete rows
 
B

Barb Reinhardt

I think I'd add a column and put this in it

=ISTEXT(A1)

I'd then autofilter and delete the entries with TRUE.
 
Top