Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.

Dismiss

Formula to pull last name error (Excel 07)

0 views

Skip to first unread message

unread,

Jan 4, 2010, 4:13:01 PM1/4/10

In A1 I have Joe Smith, I would like Smith to be in B1.

I tried using the function =RIGHT(A1,LEN(A1)-FIND(“*”,SUBSTITUTE(A1,”
“,”*”,LEN(A1)-LEN(SUBSTITUTE(A1,” “,””)))))

but am getting the #NAME? error.

FYI: I can't use the Text to Columns function because I have some names that
have at least 2 middle names...

Thanks
-B

unread,

Jan 4, 2010, 4:59:01 PM1/4/10

Maybe something like that...
[Start typing the formula(s) in column C first]
http://img695.imageshack.us/img695/346/nonamer.png
Micky

0 new messages