| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
HOW DO I EXTRACT NUMBERS FROM TEXT STRING
Then this would do that
=MID(A1,FIND("/",A1,FIND("/",A1,1)+1)+1,(FIND(" kgs",A1,1)-FIND("/",A1,FIND("/",A1,1)+1))) Watch the word wrap, mind there is a space before the kgs AndyF wrote: 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| extract numbers from a string | Excel Worksheet Functions | |||
| extract numbers from text string | New Users to Excel | |||
| Only extract numbers from a string of text | Excel Discussion (Misc queries) | |||
| EXTRACT NUMBERS FROM TEXT STRING | Excel Worksheet Functions | |||
| How do you extract numbers from a string of chacters in a cell (E. | Excel Worksheet Functions | |||
Hybrid Mode
