Formula to pull last name error (Excel 07)

  • Thread starter Thread starter Outlook, eh?
  • Start date Start date
O

Outlook, eh?

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
 
Back
Top