Text Right Function

[Leah Andersen]

I am trying to put in a function into a cell so that it
pulls just the last name.

For Example:

"John Smith" is in Cell B1 and I want just "Smith" to come
up in Cell A1.
This is a rather large database of 1,500 records and all
names are of varying length.

Thanks for any input!!!

 

[Frank Kabel]

Hi Leah
have a look at
http://www.cpearson.com/excel/FirstLast.htm

HTH
Frank

 

[Naraine]

try this,
in A1 TYPE
=MID(B1,1,FIND(" ",B1,1))

 

[Jason Morin]

This will extract the last *word*, so it helps deal with
names that have a middle initial or two first names:

=MID(A1,FIND("#",SUBSTITUTE(A1," ","#",LEN(A1)-LEN
(SUBSTITUTE(A1," ",""))))+1,255)

Of course a name like "Oscar De La Hoya" will come out
like "Hoya."

HTH
Jason
Atlanta, GA

 

[Naraine]

sorry, my previous post was to extract first name.

in A1 TYPE

=MID(B1,FIND(" ",B1,1)+1,LEN(B1))