Separating names

G

Guest

Can a column of names (last name, first name) be split into two columns, one
for the last nams and the other for the first name?
 
G

Guest

Assume that the name is cell A1.

For first name type this formula in Cell B1
=MID(A1,1,FIND(" ",A1,1)-1)

For last name type this formula in Cell C1
=MID(A1,FIND(" ",A1,1)+1,LEN(A1))

The above formula assumes that there is only 1 blank/space between first and
last name.
 

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

How do I separate first and last names into two columns? 2
separating first and last names 10
Formula To Split Name 5
Text to Columns 4
complicated text to column 4
Search two columns in list for first and last name and return Id 4
Reversing Last Name and First Names 2
text to columns using capital letters 2

Top