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

  • Thread starter Thread starter mllasalle
  • Start date Start date
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.
 
Look at Data>Text To Columns, with a separator of space or comma, depending
upon the original data.
 
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
separating first and last names 10
Search two columns in list for first and last name and return Id 4
last name alphabetical order 3
Sorting full name into 2 columns by first name and last name 3
VBA - retrieve data on last create named range from previous inserted named range 0
Data separation 1
Reversing Last Name and First Names 2

Back
Top