Formula to Seperate data in 1 cell
 

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?

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?

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?