View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
emerald
 
Posts: n/a
Default Removing Non-Numeric Characters - Automatically - How?

I am grabbing web query data to a sheet, but it comes in the form
212 p
954 p
25.25 p
555.00 p
etc.

How can I automate the removal of the non numeric data?