Hi
If the Name is Dhoni S. the output is coming as S. DHONI
Hope this is what you are after
Hi
i have uploaded without formula
Dear Faseeh,Dear Webmax,
Your output in not consistent thoroughly. How a formula can identify that MS Dhoni should be change to Dhoni MS while Dhoni S should remain Dhoni S.