IF function?

[broken.logan]

In column A I have a list of full names (first and last names). How can
I break up the full names so that the first names appear in column B
and the last names appear in column C?

 

[Peo Sjoblom]

Make sure B is empty, select A, do data>text to columns> delimited, select
the delimiter maybe space or comma (whatever that separates the names), then
click finish. This will give you the first names in A and the last names in
B, if you want to keep the original column just make a copy and put in B,
the follow the instructions from above

--
Regards,

Peo Sjoblom

(No private emails please)

 

[broken.logan]

That worked! Thanks