Your formula leaves off the trailing "dot". Here is the modification to it
in order to retain that trailing "dot"...

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

--
Rick (MVP - Excel)



"Teethless mama" wrote in message
...
Try this:

=LEFT(TRIM(RIGHT(SUBSTITUTE(A1,".",REPT(" ",99)),99))&"."&A1,LEN(A1))



"via135 via OfficeKB.com" wrote:

hi all!

i am having thousands of names in col A
the problem is the initials are before
the names..!

for example as

A.K.PRAVEEN
C.GUPTA
G.K.S.RICHARD
M.PRAVEEN
L.M.DAS

and so on..!

how can i convert the data
with initials after the name
in each cell like...

PRAVEEN.A.K.
GUPTA.C.
RICHARD.G.K.S.
PRAVEEN.M.
DAS.L.M.

so that it would be easier for
sorting the records..!

any hlp..?


-via135

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/201004/1

.