Excel Data Cleaning & Formatting
Budget: ₹400 – ₹750 INR
I have a spreadsheet that mixes numbers, text, and dates, and those dates appear in several different styles (e.g., 12/03/23, 3-12-2023, March 12 2023). I need the entire file cleaned so every date follows one clear format that I will specify once we start. While working through the file, please also check that any transformations you apply do not disturb the numeric or text fields.
Deliverables:
• A cleaned Excel workbook with all dates converted to the agreed-upon format
• A brief change log noting any assumptions or edge cases you encountered
Deliverables:
• A cleaned Excel workbook with all dates converted to the agreed-upon format
• A brief change log noting any assumptions or edge cases you encountered
Related categories:
Visual Basic
Data Processing
Data Entry
Excel
Data Scraping
Data Visualization
Data Analysis
Data Management