How do I separate first and last names into two columns?

M

mllasalle

I have received a data base with members' names. Unfortunately the list has
the first and last name in one column. I will be adding names and sorting
names in alphabetical order. How do I separate the first and last name so
that I have two distinct columns -- one for the first name and one for the
last name? Thanks for your assistance in this matter.
 
B

Bob Phillips

Look at Data>Text To Columns, with a separator of space or comma, depending
upon the original data.
 
F

FSt1

hi
an example of your data would have been nice but....
lets say we have Bart Simpson in a2
in B2 enter...
=LEFT(A2,FIND(" ",A2,1))
in C2 enter.....
=MID(A2,FIND(" ",A2,1)+1,99)

regards
FSt1
 

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

Separate First, Last Names 2
Reversing Last Name and First Names 2
Search two columns in list for first and last name and return Id 4
Separate names into 2 columns? 8
separating first and last names 10
Excel Comparing two columns 1
Parsing text in a cell 1
Concatenate first, middle and last names 1

Top