Separating a column containing a first and last name...

W

wrosie

I have a spreadsheet in which the Name column contains both first and last
name. Is there a way to make this into two columns, one for the first name
and one for the last name, for mail merge purposes without retyping all 400+
names?
 
B

Bob Phillips

Data>Text To Columns with a space delimiter

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
Top