Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
splitting first and surnames
Hi,
If I have a list of names in excel such as Craig Fox (A1) John Jones (A2) etc, how do I get excel to split the names into two columns, such as: - Craig (B1) John (B2) in one column and in the same rows the surnames appear Fox (C1) Jones (C2) I would like to do this to a long list of names Matt |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
splitting first and surnames
On Wed, 5 Apr 2006 04:03:01 -0700, mattguerilla
wrote: Hi, If I have a list of names in excel such as Craig Fox (A1) John Jones (A2) etc, how do I get excel to split the names into two columns, such as: - Craig (B1) John (B2) in one column and in the same rows the surnames appear Fox (C1) Jones (C2) I would like to do this to a long list of names Matt If the names are as you show, you could 1. Copy column A to column B 2. Select Column B 3. Use the Data/Text to columns wizard with <space as the delimiter. Or you could use formulas B1: =LEFT(A1,FIND(" ",A1)-1) C1: =MID(A1,FIND(" ",A1)+1,255) --ron |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
splitting first and surnames
Highlight the column, then Data TextToColumns Delimited and use space
for the delimiter...... Vaya con Dios, Chuck, CABGx3 "mattguerilla" wrote: Hi, If I have a list of names in excel such as Craig Fox (A1) John Jones (A2) etc, how do I get excel to split the names into two columns, such as: - Craig (B1) John (B2) in one column and in the same rows the surnames appear Fox (C1) Jones (C2) I would like to do this to a long list of names Matt |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|