need surnames in a column in excel seperate from the first names
 

If I have a column containing both first name and surnames, how do I get the
surnames into another column?

need surnames in a column in excel seperate from the first names
 

Select the column. Hit Data--Text to columns. See more about it in this
article:
http://www.officearticles.com/tutori...soft_excel.htm

****************************
Hope it helps!
Anne Troy
www.OfficeArticles.com
****************************
"Irish girl" <Irish wrote in message
...
If I have a column containing both first name and surnames, how do I get
the
surnames into another column?

need surnames in a column in excel seperate from the first names
 

Another way using formulas, assuming you have the names in A1 and they all
have the first name first and are separated by a space,
=LEFT(A1,FIND(" ",A1)-1)
for the first name,
=RIGHT(A1,LEN(A1)-FIND(" ",A1))
for the second name.
Copy Paste special Values to lose the formulas.
These can go in any cell rather than having to have columns B and C empty as
is necessary using Text to Columns. If Columns B and C are empty and
available, Text to Columns is the easier option.
Regards,
Alan.

"Irish girl" <Irish wrote in message
...
If I have a column containing both first name and surnames, how do I get
the
surnames into another column?