Remove All Characters except numbers from one column only.

Hi,

I have a worksheet that I need to remove text from but leave numbers:

Cell C4 contains the following text:
Supermarket 328 Chicago, Il

and I just want it to say "328"

and to do the same for the entire column C.

So I need to select Column C, Search for each character not associated with 0-9 and remove it.
The last macro I wrote would remove all non-numeric characters from the entire worksheet, not just my one column.

Any help would be great.

Thanks

Hi tdal,
Here is some code shamelessly stolen from the internet that should do the trick.

Please Login or Register  to view this content.

Tom Urtis has a good macro here in Post #6:
http://www.mrexcel.com/forum/excel-q...rs-string.html

See
http://www.mrexcel.com/forum/excel-q...ml#post1794525