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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula help 1
Formula Correction 5
RIGHT not doing anything 3
Conundrum 7
RT- error 1004 3
why won't text-to-columns work here? 6
Max Length in a row 1
Question for Bob Phillips re Splitting Names from Cells 8

Back
Top