Excel Title Case Conversion

I need help standardising the text in an Excel workbook. Several columns are filled with names, product titles, and location fields that now appear in random mixtures of upper- and lower-case letters. Every entry should read in proper Title Case—first letter of each word capitalised and the rest in lower-case.

The job is straightforward but must be done with precision. A quick PROPER() formula works for most cells, yet I also expect you to catch exceptions such as “USA”, “eBay”, or common abbreviations that shouldn’t be converted blindly. You are free to rely on formulas, Power Query, or a small VBA macro; just make sure the method is repeatable so I can apply it to future files.

Deliverables
• My original spreadsheet returned with every relevant text field converted to Title Case
• A short note inside the file (or separate text doc) explaining the exact steps, formula, or macro used so I can reproduce the process on my side

Turnaround within two days is ideal, but let me know if you need slightly longer.