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
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
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.
--
Earl Kiosterud
www.smokeylake.com/
-------------------------------------------
"Antonio" <[email protected]> wrote in message
news:[email protected]...
> 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" <[email protected]> wrote in message
news:[email protected]...
> 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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks