THANK YOU! I DON'T KNOW WHAT I DID BEFORE. PERFECT!

"Ron de Bruin" wrote:

Hi v

Try it on a new sheet and you see that this is not the problem of the function

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Barb" wrote in message ...
If I put the formula in B1, the last name appears in B1 but C1 becomes a
merged cell with B1 and both cells have a dark grey background.

"Ron de Bruin" wrote:

Works great except it uses up two lines for the answer & it has a grey
background.

I do not understand you ?



--
Regards Ron de Bruin
http://www.rondebruin.nl


"Barb" wrote in message ...
Works great except it uses up two lines for the answer & it has a grey
background.

"Ron de Bruin" wrote:

Hi Barb

Try this formula with the name in A2

=IF(ISERR(FIND(" ",A2)),A2,MID(A2,FIND("^^",SUBSTITUTE(A2," ","^^",LEN(A2)-LEN(SUBSTITUTE(A2," ",""))))+1,1024))

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Barb" wrote in message ...
I want to extract a person's last name from a field & put it into another for
sorting purposes. If their name is Bud Line, I want to put Line into a
different field. If their name is Betsy Sue Color, I want to put Color into
a different field. I think their should be a way to search for the space
starting from the right side, but I don't know how. The problem I'm having
is if their name is listed as first, middle and last.