| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy only the number from a text string
Hi Trevor,
"Trevor Shuttleworth" wrote in message ... Let's try this: =VALUE(MID(RIGHT(A3,6),FIND(" ",RIGHT(A3,6))+1,LEN(RIGHT(A3,6))-FIND(" ",RIGHT(A3,6)))) That one doesn't work for me with a value like "a a 233" or similar. It seems that it won't work for anything with 2 separate spaces in the last 6 digits. Regards, Jake Marx MS MVP - Excel |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Converting a text word or text string to a number | Excel Discussion (Misc queries) | |||
| Change 3 letter text string to a number string | Excel Discussion (Misc queries) | |||
| Copy Text String from between () | Excel Worksheet Functions | |||
| Extract number from text/number string.. | Excel Discussion (Misc queries) | |||
| Splitting a text string into string and number | Excel Discussion (Misc queries) | |||
Threaded Mode
