Thread: parsing a string for 3 sets of numbers
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
micah micah is offline
external usenet poster
  
Posts: 15
Default parsing a string for 3 sets of numbers
I have a spreadsheet with various words and numbers in each cell. The
arrangement of numbers in the string can vary. I want to extract from the
text string, the first 3 numbers as numbers.

Example

dog a cat 45672 223 12.42 mouse caught

I want to parse the above string (which is in a cell) and get
45672
223
12.42
Reply With QuoteReply With Quote