Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Formula to separate text in cell
I need to find a formula that will separate first & last name in a single
cell and put into 2 separate cells. Any help would be appreciated. |
#2
|
|||
|
|||
Formula to separate text in cell
Hi Steph,
Suppose you have name John Brown in E2, and you want John in F2 and Brown in G2. I assume theres a space between John and Brown. Type in F2:- =Left(E2,Find(" ",E2,1)-1) Type in G2:- =Right(E2,Find(" ",E2,1)) hope this helps, Yorkie "Steph" wrote: I need to find a formula that will separate first & last name in a single cell and put into 2 separate cells. Any help would be appreciated. |
#3
|
|||
|
|||
Formula to separate text in cell
Thanks!!!
"Yorkie118" wrote: Hi Steph, Suppose you have name John Brown in E2, and you want John in F2 and Brown in G2. I assume theres a space between John and Brown. Type in F2:- =Left(E2,Find(" ",E2,1)-1) Type in G2:- =Right(E2,Find(" ",E2,1)) hope this helps, Yorkie "Steph" wrote: I need to find a formula that will separate first & last name in a single cell and put into 2 separate cells. Any help would be appreciated. |
#4
|
|||
|
|||
Formula to separate text in cell
Still running into problems with this formula with longer names, or with a
name in the following format, for example: McCullough, Reginald - if I follow your formula I get "McCullough," in one column and "gh, McCullough" in the next. I can change the formula for the first one to eliminate the comma, but don't know how to just get the first name in the next column. Keep in mind, all of the names, both first & last, have a varying number of characters. "Yorkie118" wrote: Hi Steph, Suppose you have name John Brown in E2, and you want John in F2 and Brown in G2. I assume theres a space between John and Brown. Type in F2:- =Left(E2,Find(" ",E2,1)-1) Type in G2:- =Right(E2,Find(" ",E2,1)) hope this helps, Yorkie "Steph" wrote: I need to find a formula that will separate first & last name in a single cell and put into 2 separate cells. Any help would be appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Text in formula bar is not displaying in cell | Excel Discussion (Misc queries) | |||
Is there a formula for IF a cell CONTAINS certain text... | Excel Worksheet Functions | |||
Text in Cell as Formula | Excel Discussion (Misc queries) | |||
reference the result of a formula in a text formatted cell | Excel Discussion (Misc queries) | |||
GET.CELL | Excel Worksheet Functions |