Extracting part of a string

  • Thread starter Thread starter Ken Mahler
  • Start date Start date
K

Ken Mahler

Greetings,

I have a name value in A1,eg: Mr. Joe Smith. I need a function/formula that
will find the space just before the last name -- the 1st space character
from the right -- and extract everyting to the right of it so I get just the
last name in cell A2.

TIA

Ken
 
One way:

=MID(A1,FIND("#",SUBSTITUTE(A1," ","#",LEN(A1)-LEN
(SUBSTITUTE(A1," ",""))))+1,255)

HTH
Jason
Atlanta, GA
 
Have you considered using the Data, Text to Columns command?

It worked very well on your sample.
 
Back
Top