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