One way:

=TRIM(MID(A1,FIND(" ",A1&" "),255))

Biff

"WDP" wrote in message
...
Hi:

I am looking for a function in Excel to extract the LAST NAME from a cell
that looks like:

Justin Kenney

I want the formula to give me only the last name (ie Kenney)

Can anyone help with a formual (maybe the RIGHT function) that looks RIGHT
TO LEFT for the 1st space...and then gives me everything to the RIGHT of
the
space

Thanks
Warren