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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Data>Text To Columns with a space delimiter

--
HTH

Bob Phillips

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