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

Formula to compare numbers in 3 columns 1
Formula to compare numbers in 3 columns 3/23/08 7
Excel 2002: How to eliminate empty spaces ? 1
Excel 2002 : Quik way of getting customer name 1
How to reference a worksheet name 6
Copy an Drag cell Formula Problem 1
if/and array in MS Excel 2003 0
Count formula 5

Top