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?