modify Reverse name formula

[shrinivasmj]

hi

=UPPER(LEFT(TRIM(RIGHT(SUBSTITUTE(TRIM(N3)," ",REPT(" ",99)),(1+(LEN(N3)-LEN(SUBSTITUTE(N3," ",""))>2)+(LEN(N3)-LEN(SUBSTITUTE(N3," ",""))>4))*99))&","&N3,LEN(N3)))

the above formula is this way

srinivas shinda singh will come Output- SINGH,SRINIVAS SHINDA upto 3 words will take last single word reverse

srinivas shinda singh kumar Output -SINGH KUMAR,SRINIVAS SHINDA upto 4 to 6 words need to take 2 last words reverse

srinivas shinda singh kumar sons Output-SINGH KUMAR SONS,SRINIVAS SHINDA SINGH above 6 words need to take last 3 words reverse .

this all i am getting in above formula need to get if this single character comes with dot.

Srinivas m.t. OUTPUT T,SRINIVAS M.

Srinivas m.t.i. OUTPUT T.I,SRINIVAS M.

srinivas m.t.i.l.k. OUTPUT I.L.K,SRINIVAS M.T.

need to edit the above formula and add this changes to above formula i need all the out put in one formula

 

[Rick Rothstein]

This question is cross posted here in its original thread...

http://www.mrexcel.com/forum/excel-questions/656422-reverse-name-excel-upper-case.html#post3263926

and here in another forum...

Reverse name in excel with upper case,edit formula

 

[shrinivasmj]

hi need it very urgent ,i think you can only solve it

this out put is not comming

Srinivas m.t. OUTPUT T,SRINIVAS M.

Srinivas m.t.i. OUTPUT T.I,SRINIVAS M.

srinivas m.t.i.l.k. OUTPUT I.L.K,SRINIVAS M.T.

 

[shrinivasmj]

hi need it very urgent ,i think you can only solve it

this out put is not comming

Srinivas m.t. OUTPUT T,SRINIVAS M.

Srinivas m.t.i. OUTPUT T.I,SRINIVAS M.

srinivas m.t.i.l.k. OUTPUT I.L.K,SRINIVAS M.T.