<div>
Does the job both of them but just chose the SimonAdept solution as best solution for its elegance and flexibility. But both do the job.
</div>


Does the job both of them but just chose the SimonAdept solution as best solution for its elegance and flexibility. But both do the job.

<div>
<div class="content wysiwyg-content">
I got a question about ways to clean up the following..<br />
someone has entered Mc Donald instead of McDonald or MacDonald. Or someone enters O Brien instead of O'Brien....is there a way to tidy up the data in Excel to the desired format? Thanks :-)
</div>
</div>


I got a question about ways to clean up the following..
someone has entered Mc Donald instead of McDonald or MacDonald. Or someone enters O Brien instead of O'Brien....is there a way to tidy up the data in Excel to the desired format? Thanks :-)

tidy up Mc/Mac/O in Excel database

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