Hi
use
=MID(A1,FIND(".",A1)+1,255)
--
Regards
Frank Kabel
Frankfurt, Germany
"Sho" schrieb im Newsbeitrag
...
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?
|