| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I want to get remaining text after using LEFT function
Biff wrote...
Not a whole lot of detail to go on. A1 = some string B1 = some formula using LEFT that returns a portion of the string in A1 C1 = formula to return the rest of the string: =SUBSTITUTE(A1,B1,"") Safer to make that =SUBSTITUTE(A1,B1,"",1) in case the B1 formula were something like =LEFT(A1,FIND(" ",A1)-1) and A1 were something like Robert Robertson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If function with text | New Users to Excel | |||
| text function | Excel Worksheet Functions | |||
| Excel Text Function (Right, Left) | Excel Discussion (Misc queries) | |||
| how to make number as text and left justified? | Excel Worksheet Functions | |||
| Excel IF function for text | Excel Worksheet Functions | |||
Hybrid Mode
