On Apr 4, 12:32*am, "Rick Rothstein"
wrote:
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)

yes..
=MID(A1&"."&A1,LEN(A1)-LEN(TRIM(RIGHT(SUBSTITUTE(A1,".",
REPT(" ",99)),99)))+1,LEN(A1)+(NOT(ISERR(FIND(".",A1) ))))
this one works fine..!

thks Rothstein for fixing up the problem..! thks again

-via135