Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Separating names
Can a column of names (last name, first name) be split into two columns, one
for the last nams and the other for the first name? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Separating names
Assume that the name is cell A1.
For first name type this formula in Cell B1 =MID(A1,1,FIND(" ",A1,1)-1) For last name type this formula in Cell C1 =MID(A1,FIND(" ",A1,1)+1,LEN(A1)) The above formula assumes that there is only 1 blank/space between first and last name. -- Pranav Vaidya VBA Developer PN, MH-India If you think my answer is useful, please rate this post as an ANSWER!! "Stewart99" wrote: Can a column of names (last name, first name) be split into two columns, one for the last nams and the other for the first name? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Separating names
Select the column then:-
data|text to columns The wizard is fairly intuative Mike "Stewart99" wrote: Can a column of names (last name, first name) be split into two columns, one for the last nams and the other for the first name? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
separating first and last names | Excel Discussion (Misc queries) | |||
Separating Names in a Cell | Excel Discussion (Misc queries) | |||
Separating Names in a cell | Excel Discussion (Misc queries) | |||
separating names | Excel Worksheet Functions | |||
Separating names | Excel Worksheet Functions |