Text string manipulation...
Try this:
=MID(A1,FIND("~",SUBSTITUTE(A1," ","~",LEN(A1)-LEN(SUBSTITUTE(A1,"
",""))))+1,99)
"NWO" wrote:
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
|