Split Names

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello, everybody. This is my first post in an excel newsgroup. Here is the
question:

I have a "Name" column which lists individuals' First and Last names. Is it
possible to split into two columns, FirstName and LastName? Thanks
 
Hi,
assume you have data in A1 so formulae is :
=LEFT(A1,FIND(" ",A1,1)) [[ Put this formulae in B1 for First
Name]]
=RIGHT(A1,LEN(A1)-FIND(" ",A1,1)) [[Put this formulae in C1 for Last
Name]]

Thnx
Dushyant
 
Antonio,

You can use Data - Text to columns. Make sure there are two empty columns
to the right. If there are more than two names in any (as determined by
spaces between them), you'll need more columns. Select the column, Data -
Text to columns. Specify the space as the delimiter.
 

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

Text parsing 3
Mobile phone texts split into incoming and outgoing messages 0
Separating First Name(s) and Last Name into Separate Columns 3
Split name cell 2
Split LastName, First Name column into 2 seperate columns 9
Excel 2003 - Changing FirstName LastName to LastName, Firstname 3
Spliting Names 2
moving first word in a column to a separate column 8

Back
Top