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

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

Bob Phillips

Data>Text To Columns with a space delimiter

--
HTH

Bob Phillips

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Reversing Last Name and First Names 2
separating first and last names 10
How do I separate first and last names into two columns? 2
Separating names 2
complicated text to column 4
reformat a cell from last name, first to first space last? 5
Separating Names 3
Search two columns in list for first and last name and return Id 4

Top