With your name in A1 try

=TRIM(RIGHT(SUBSTITUTE(A1," ",REPT(" ",99)),99))

If this post helps click Yes
---------------
Jacob Skaria


"John" wrote:

How do I extract the last word in a character string of words and spaces?

I appreciate your help, -John