Reverse name in excel with upper case,edit formula
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
