Excel Data Cleanup Preservation
Budget: ₹12,500 – ₹37,500 INR
I have an Excel worksheet that logs comments alongside their original text, the date each comment was made, and the commenter’s name. I need the sheet cleaned without disrupting any of those three key fields.
The job centres on data cleaning only. Specifically, I want two things handled:
• Text-level fixes: adjust capitalization so sentences read consistently and fix any misaligned text in each cell.
• Date corrections: bring all date entries into a single, valid Excel date format (no hard-typed strings or mixed styles).
Throughout the process the source text, the date value itself, and the commenter name must stay exactly as they are—only the formatting changes. When you return the file I should be able to filter and sort without issues, and no duplicates or extra spaces should appear as side effects.
Deliverable: the same workbook returned as a clean, ready-to-use file.
I’ll send the sheet as soon as we start; looking forward to your expertise in Excel’s data-cleaning tools, formulas, and power-query features to make this a quick, accurate turnaround.
The job centres on data cleaning only. Specifically, I want two things handled:
• Text-level fixes: adjust capitalization so sentences read consistently and fix any misaligned text in each cell.
• Date corrections: bring all date entries into a single, valid Excel date format (no hard-typed strings or mixed styles).
Throughout the process the source text, the date value itself, and the commenter name must stay exactly as they are—only the formatting changes. When you return the file I should be able to filter and sort without issues, and no duplicates or extra spaces should appear as side effects.
Deliverable: the same workbook returned as a clean, ready-to-use file.
I’ll send the sheet as soon as we start; looking forward to your expertise in Excel’s data-cleaning tools, formulas, and power-query features to make this a quick, accurate turnaround.