Split Names

A

Antonio

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
 
D

Dushyant Rajput

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
 
E

Earl Kiosterud

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