View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bernard Liengme Bernard Liengme is offline
external usenet poster
 
Posts: 4,393
Default Extracting numbers from a text

Give us a few more examples of what you input can look like so we can better
advise
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"AshMorK" wrote in message
...
How can i extract just the numbers from a text cell??

Example: Turn this: 000 234 -1 k -- into this: 2341