Reverse Name with upper case and break with comma

[shrinivasmj]

hi currently using this formula ,



i need , if the name as space after dot . output need to take space
after dot or if no space after dot need to take with out space after
dot in output.

NEED TO GET same output for one formula NEED TO EDIT .




EG,



INPUT OUTPUT

[TABLE="class: cms_table_cms_table, width: 595"]
<tbody>[TR]
[TD]N. Yulia Worbe[/TD]

[TD]WORBE,N. YULIA[/TD]

[TD]( NED TO TAKE AS INPUT SPACE AFTER DOT )[/TD]

[/TR]

</tbody>[/TABLE]




[TABLE="class: cms_table_cms_table, width: 595"]
<tbody>[TR]
[TD]n.t. Romain[/TD]

[TD]ROMAIN,N.T.[/TD]

[TD]( No Space After Dot IN INPUT )[/TD]

[/TR]

</tbody>[/TABLE]




formula..........used

=UPPER(MID(TRIM(SUBSTITUTE(H14,".",".
"))&","&TRIM(SUBSTITUTE(H14,".",".
")),FIND("$",SUBSTITUTE(TRIM(SUBSTITUTE(H14,".",". ")),"
","$",LOOKUP(LEN(TRIM(SUBSTITUTE(H14,".",".
")))-LEN(SUBSTITUTE(TRIM(H14),"
",""))+1,{0,4,6},(LEN(TRIM(SUBSTITUTE(H14,".",".
")))-LEN(SUBSTITUTE(SUBSTITUTE(H14,".",". "),"
","")))-{0,1,2})))+1,LEN(TRIM(SUBSTITUTE(H14,".",". ")))))

---

---

I need to Reverse Name with upper case and break with comma



need to break the name in half part and reverse the name with comma
,and need to take dot as one word like EG- shrinivas m.j. are 3 words .



1 to 3 words reverse last word





> 4 to 5 words reverse last 2 words



> 6 to 7 words reverse last 3 words

 

[Jborg]

Enter the formula Ctrl+shift+enter

 

[Jborg]

enter the formula ctrl+shift+enter

 

[Jborg]

enter the formula ctrl+shift+enter

 

[shrinivasmj]

thanks