Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I want to get remaining text after using LEFT function
Pls tell me the solution.
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I want to get remaining text after using LEFT function
Maybe MID would fit the bill ?
Perhaps an example to illustrate Assuming A1 contains: text1 text2 with similar in A2 down and we want to split col A into cols B and C In B1: =LEFT(A1,SEARCH(" ",A1)-1) In C1: =MID(A1,SEARCH(" ",A1)+1,99) B1 returns: text1 C1 returns: text2 (the "99" in MID is arbitrary, adjust the number to suit) To split it similarly for A2, A3, A4 ...., just select B1:C1 and copy down -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Munawar Amin" wrote: Pls tell me the solution. I want to get remaining text after using LEFT function |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I want to get remaining text after using LEFT function
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,"") Biff "Munawar Amin" <Munawar wrote in message ... Pls tell me the solution. |
#4
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 |