Excel Title-Case Text Cleanup

via Freelancer ·

Budget / SalaryHourly project
TypeFreelance project
LocationRemote
Posted1 hour ago
I have an Excel worksheet that contains only text fields—names, addresses, and assorted descriptions. The content has been entered at different times, so capitalization is inconsistent and sometimes peppered with stray spaces or line breaks. My sole objective is to bring every text cell into perfect Title Case and leave the worksheet otherwise unchanged.

You may rely on any Excel-friendly method you prefer—formulas, Flash Fill, Power Query, or a quick VBA routine—as long as the end result is clean and accurate.

Deliverables
• A single .xlsx file with every text entry converted to Title Case, original sheet structure, order, and formatting (other than capitalization) fully preserved.
• A brief note outlining the method you used and any assumptions or edge cases you handled.

Acceptance Criteria
• All text strings read in Title Case (e.g., “john DOE” becomes “John Doe”).
• No added or missing rows, columns, or formulas.
• No extra spaces at the beginning or end of any cell.
• File opens without compatibility warnings in the current desktop version of Microsoft Excel.

Turnaround is flexible but sooner is better; accuracy is the priority.
visual basic data processing data entry excel excel vba excel macros data analysis data management
Apply on Freelancer →

Project sourced from Freelancer.com. Applications happen directly on the original platform — we never collect your data.