Formula to pull last name error (Excel 07)

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

how do I use macro to find and replace unicode characters 6
Excel 2002: How to eliminate empty spaces ? 1
Excel 2002 : Quik way of getting customer name 1
Formula to compare numbers in 3 columns 3/23/08 6
Copy an Drag cell Formula Problem 1
How to reference a worksheet name 6
Locking info in cells 3
Date Formula 13

Top