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
 
Back
Top