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

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?

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?