| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
second word in a string
Hello How Do I extract anything after the first word example column AU
reads Massapequa 5 Prime so in this instance I want to extract 5 prime this is my messed up formula =TRIM(MID(AU4,SEARCH(" ",AU4)+3,255)) I get PRIME . Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| return 1st word in string | Excel Discussion (Misc queries) | |||
| Extracting a word from a text string | Excel Discussion (Misc queries) | |||
| Find last word in a string | Excel Discussion (Misc queries) | |||
| choose a particular word in a string | Excel Discussion (Misc queries) | |||
| Word select from a string | Excel Worksheet Functions | |||
Threaded Mode
