Thank you. Can you please explain the use of the ^^^ symbols as used in your
function?

Thank you again.

Mark :)

"Ragdyer" wrote:

With list of names starting in A1, try this in B1:

=RIGHT(A1,LEN(A1)-FIND("^^^",SUBSTITUTE(A1,"
","^^^",LEN(A1)-LEN(SUBSTITUTE(A1," ","")))))

Copy down as needed.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"NWO" wrote in message
...
Hi.

Seems simple, but not for me...

I have a list of names in the format John N Jones (no commas). I want to
only capture the last name (i.e. Jones) in another cell. How do I
accomplish
this. I already tried the Pearson site, but no help. No code please.

Thank you.

Mark