Formula help...right/find command
=RIGHT(A1,LEN(A1)-FIND(" ",A1))
BUT only there are two names: Cliff M Lee will return "M Lee"
"Jambruins" wrote:
In cell N92 there is a name (Cliff Lee). I would like a formula in cell Z92
to get the last name (Lee) from cell N92. I have more names in column N that
I want to do the same thing to. What formula should I use? I am trying to
use the right and find commands but I cant get it to work. Thanks.
|