Uh, this formula is the correct one to use...

=MID(A1&"."&A1,LEN(A1)-LEN(TRIM(RIGHT(SUBSTITUTE(A1,".",
REPT(" ",99)),99)))+1,LEN(A1)+(NOT(ISERR(FIND(".",A1) ))))

--
Rick (MVP - Excel)



"Rick Rothstein" wrote in message
...
Your formula is missing a first letter of the surnames

????

That is not the case on any of the tests I've performed here. I do note
that the trailing "dot" is missing though. Try this formula and make sure
you don't have a trailing blank space after the name...

=MID(A1&"."&A1,LEN(A1)-LEN(TRIM(RIGHT(SUBSTITUTE(A1,".",REPT("
",99)),99)))+1,LEN(A1)+1)

--
Rick (MVP - Excel)