Edit name Formula if single text with dot take as a word

[shrinivasmj]

hi

i have formula were i need some changes

=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)))


INPUT IS -Jacqueline M.R. Belanger

OUT PUT IS - BELANGER,JACQUELINE M.R.

i need the out put as R.BELANGER,JACQUELINE M.

single dot in the name EG- M.T. as to be taken as one word and break the name.

Regards
srinivasmj

 

[Gary's Student]

How about:

=MID(N3,FIND(".",N3)+1,256) & "," & LEFT(N3,FIND(".",N3))
or
=UPPER(MID(N3,FIND(".",N3)+1,256) & "," & LEFT(N3,FIND(".",N3)))

 

[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