| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Extracting Text From Right To Left - MID & FIND
Lars-Åke Aspelin wrote:
On Wed, 6 Jan 2010 08:15:01 -0800, Gary Brown wrote: Assuming your data is in cell A1 ... =MID(A1,(FIND(" ",A1,(FIND("h",A1))-11))+1,(FIND("h",A1))-(FIND(" ",A1,(FIND("h",A1))-11))-1) should do it. This formula relies on that there is only one " " within the 11 characters immediate to the left of "h". But we don't know that, do we? Lars-Åke Use the formula I posted on one of Brenda's other threads: =TRIM(MID(SUBSTITUTE(A1," ",REPT(" ",99)), FIND("h",SUBSTITUTE(A1," ",REPT(" ",99)))-99,99)) Will work unless the text prior to the "h" is more than 99 characters. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Extracting Text From Right To Left - MID & FIND | Excel Worksheet Functions | |||
| FIND from right to left instead of left to right | Excel Worksheet Functions | |||
| Extracting information to automatically find previous value. | Excel Worksheet Functions | |||
| Help putting left, right, find and len together | Excel Discussion (Misc queries) | |||
| Find text within cell then display text to left | Excel Discussion (Misc queries) | |||
Hybrid Mode
