IF function?

B

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?
 
P

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)
 
Top