Thread: HOW DO I EXTRACT NUMBERS FROM TEXT STRING
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob I Bob I is offline
external usenet poster
  
Posts: 2,819
Default HOW DO I EXTRACT NUMBERS FROM TEXT STRING
As in the number(s) between the second "/" and the " kgs" ?

AndyF wrote:
I need to extract specific numbers from a text string that varies.

For example: I need to extract the second weight from each text i.e 9.
' GW/NW: 10/9 kgs'

Can anyone help please?


Reply With QuoteReply With Quote