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