This should do it for you.
=RIGHT(A1,LEN(A1)-FIND(".",A1))
"Sho" wrote:
I have names on a sheet that I am trying to separate e.g. John.Smith
If I do the formula = Left(A1,Find(".",A1)-1) it returns John in the cell
which is correct however if I do the formula Right(A1,Find(".",A1)-1) it
works on some names and not others. Any idea of a formula where I can just
extract the surname?
|