Hi,
Can I please ask for help, this is the formula im using
=PROPER(RIGHT(O4,LEN(O4)-SEARCH(".",O4))&" "&LEFT(O4,SEARCH(".",O4)))
the result of the formula is at Name Row
=PROPER(RIGHT(O4,LEN(O4)-SEARCH(".",O4))&" "&LEFT(O4,SEARCH(".",O4)))
I wanted to make the name look like Abbas, Shin...