rearranging_names
On Apr 3, 10:55*pm, "Rick Rothstein"
wrote:
You can use this formula to reverse the initials and surnames...
=MID(A1&"."&A1,LEN(A1)-LEN(TRIM(RIGHT(SUBSTITUTE(A1,".",REPT("
",99)),99)))+1,LEN(A1))
--
Rick (MVP - Excel)
"via135" wrote in message
...
hi all!
i am having names in COL -A
all begining with intials followed by the name
and some names without initials as under:
M.GUPTA
C.K.S.BANERJEE
RAMAN
M.M.K.S.MOHAN
L.T.PRABA
S.LAL
and so on..!
what i want is to rearrange
the names to begin with the name
followed by initials..like
GUPTA.M.
BANERJEE.C.K.S.
RAMAN
MOHAN.M.M.K.S.
PRABA.L.T.
LAL.S.
so that it would be easier for
sorting the names..!
any help please?
-via135
hi Rothstein.!
i am getting the results like....
..GUPTA.
..S.BANERJEE.C.
RAMAN
K.S.MOHAN.M.M
T.PRABA.L
..LAL.
|