<div>
Thank you very much Sir. &nbsp;Worked like a charm!
</div>


<div>
You're welcome. Glad to help.
</div>


<div>
<div class="content wysiwyg-content">
Hello EE,<br />
<br />
Can someone please help me with an excel formula to remove comma and switch the string before the commas to the end of the string? I have the following example:<br />
<br />
III, Wallace James<br />
Janet Rhodes,<br />
Adu, Mary Ann<br />
<br />
Should be<br />
<br />
Wallace James III<br />
Janet Rhodes<br />
Mary Ann Adu<br />
<br />
Thanks in advance for your help
</div>
</div>


Hello EE,

Can someone please help me with an excel formula to remove comma and switch the string before the commas to the end of the string? I have the following example:

III, Wallace James
Janet Rhodes,
Adu, Mary Ann

Should be

Wallace James III
Janet Rhodes
Mary Ann Adu

Thanks in advance for your help

How Can I switch string

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.