View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Corey
 
Posts: n/a
Default Extract Numerics only

Hello. I have a column with data that contain numerics and text:

ON 3127
ON2679
O/F 20R
OFF///130H

Is there a formula I can input in an adjacent cell to only pull out the
numbers to give me the following:

3127
2679
20
130

Any help is appreciated. Thanks!