View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
AndyF AndyF is offline
external usenet poster
 
Posts: 3
Default HOW DO I EXTRACT NUMBERS FROM TEXT STRING

That's correct Bob!

"Bob I" wrote:

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?