You could use a right/find combo but Data-text to columns Tab delemited with
space checked would be easier
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"alex" wrote:

Hello experts,

I'm attempting to write a function that will return part of a name.

E.g., I have the name John Doe in cell A1. I want the cell B1 to
populate with "Doe."
I could use a number of functions that come to mind, but none that
would deal with different length strings.

E.g., I have the name John Smith in cell A2. I want the cell B2 to
populate with "Smith."

thanks for any help,
alex