| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pulling text from the right end of a string
On Thu, 3 Jul 2008 12:55:24 -0400, "Rick Rothstein \(MVP - VB\)"
wrote: Give this a try... =TRIM(MID(A1,FIND("|",SUBSTITUTE(A1,"-","|",LEN(A1)-LEN(SUBSTITUTE(A1,"-",""))))+1,99)) Note.... it returns your number as text; if you want it to be a real number, use this formula instead... =--TRIM(MID(A1,FIND("|",SUBSTITUTE(A1,"-","|",LEN(A1)-LEN(SUBSTITUTE(A1,"-",""))))+1,99)) Rick Given the format of the data, =TRIM(RIGHT(SUBSTITUTE(A1," ",REPT(" ",99)),99)) should also work. If you really want to use the hyphen, then: =TRIM(RIGHT(SUBSTITUTE(A1,"-",REPT(" ",99)),99)) --ron |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| pulling certain characters from a string of text | Excel Discussion (Misc queries) | |||
| Pulling a # from a sheet bound text string | Excel Worksheet Functions | |||
| Pulling Year from a text string | Excel Worksheet Functions | |||
| Pulling String | Excel Programming | |||
| Pulling string | Excel Programming | |||
Threaded Mode
