Prev: how do I sort by picked-up date in Excel
Next: How do I make first row sort in table
From: Rick Rothstein on 1 Apr 2010 14:47
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" <Teethlessmama(a)discussions.microsoft.com> wrote in message
news:A738663B-4A48-4B05-95C5-6BADC4BDF5C6(a)microsoft.com...
> 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.aspx/excel-functions/201004/1
>>
>> .
>>
First  |  Prev  | 
Pages: 1 2
Prev: how do I sort by picked-up date in Excel
Next: How do I make first row sort in table