Delete Words Not Numbers

  • Thread starter Thread starter evoxfan
  • Start date Start date
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?
 
Select the column
F5>Special
Constants
Uncheck all under Formulas except Text
OK

You can no delete the cells or complete rows
 
I think I'd add a column and put this in it

=ISTEXT(A1)

I'd then autofilter and delete the entries with TRUE.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Appending Text To Numbers ? 1
Prefixing a number to the number in a cell 2
Word How to delete line in Word 3
Custom Number Format for text 8
Text to Numbers 4
Conditional SUBTOTAL in XL210 Table 7
Counting mixed formats in a column 2
formula to count text entries and return text with most entries 8

Back
Top