Try...

=RIGHT(A1,LEN(A1)-SEARCH("^^",SUBSTITUTE(A1,"
","^^",LEN(A1)-LEN(SUBSTITUTE(A1," ","")))))

Hope this helps!

In article ,
"maryj" wrote:

I have names of individuals in Column A. Some have only first and last,
others also include the middle initial. I want to extract the last name of
each person into Column B. I used the formula =RIGHT(A1,LEN(A1)-SEARCH("
",A1)) which works great for those names that don't include the middle
initial. How can I modify this to work for either situation? Thanks!!!