Removing all text from a column of cells

**jimbob** · 02-07-2009, 01:46 PM

I looked everywhere but could not find a solution to this.

I have a column that contains numbers and text. Some cells contain just numbers, some just text and some a combination. There is no pattern. Is there a way to remove just the text?

Here's an example:

5,000
4,000cc
none
4k credit
0

**VBA Noob** · 02-07-2009, 02:07 PM

See if link helps

http://office.microsoft.com/en-us/ex...549011033.aspx

VBA Noob

**jimbob** · 02-07-2009, 05:01 PM

That works pretty good except for one thing. Many of these cells in the Col contain empty cells so I get a bunch with #NA. Is there a way to combine this with the IF function? (IF cell is blank, then return " ")

Thanks for the help, I really appreciate it. This site has saved me hours of work.