Possible to output last word in a text cell that contains several words?

Here's my dilemna:

I have a list of full names of people. I want just their last names to be in a cell all by themselves

For example: "John A Smith" would be in one cell, but i want just "Smith" in another cell.

I tried the 'text to columns' approach using the space delimiter approach and that would've worked except for 2 problems... some names begin with a "Mr." or "Mrs." and some names would not have a middle initial.

So for example, you could have "Mr. John A Smith" or "John Smith" or "Mr. John Smith", etc. etc.

My solution would be to have some function to pick just the very last word in the cell. Is there something like that available? Or something similar? Thanks in advance!

Originally Posted by oldchippy

Hi,

If your name is in A1, try this

Please Login or Register  to view this content.

I'll try this out when i get to work, thanks!

Originally Posted by Phokus

I'll try this out when i get to work, thanks!

It worked, thanks oldchippy!