Top 10 Excel Functions for Data Cleaning @chandoo_
Top 10 Excel Functions for Data Cleaning  @chandoo_
Uploaded May 2025 | Updated November 2026, 3 hours ago
Clean Data in Excel with this PRO with these amazing "new" functions.

Gone are the days of manual data cleaning. Nowadays, Excel offers amazing functions to automate the data cleaning process. In this masterclass, learn the super tricks and become a data cleaning PRO.

✅ Reshaping data with WRAPROWS and TAKE
✅ Stacking data with HSTACK and VSTACK
✅ Removing excess spaces with TRIM
✅ Replacing typing errors and synonyms with a mapping table and XLOOKUP
✅ Replacing missing values with IF function
✅ Extracting values from text using TEXTSPLIT, TEXTBEFORE and TEXTAFTER functions
✅ Date formatting with DATEVALUE
✅ Using IFERROR & SUBSTITUTE to deal with annoying date problems
✅ Using REGEXTRACT to get data that matches the pattern we want
✅ Non-REGEX formula with TEXTSPLIT
✅ Removing duplicate data values with UNIQUE function

📁 Sample Data File:
Download the data file and practice all these functions yourself - chandoo.org/wp/wp-content/uploads/2025/05/data-cleaning-super-tricks.xlsx

🕐 Video Topics & timestamps:
0:00 - Excel Data Cleaning Supertricks
2:31 - Using WRAPROWS to reshape data
4:12 - Combining both datasets using VSTACK
7:00 - Cleaning the Person column with TRIM & CHOOSECOLS
8:14 - Replacing errors & synonyms in City column with XLOOKUP
10:38 - Using LET & IF functions to clean the price data
12:15 - Extracting "date" of the event from event detail column
14:58 - Converting date to correct format with DATEVALUE
16:38 - Fixing errors with Date Conversion
20:04 - Using REGEXTRACT to extract the event time details
25:10 - non-REGEX formula for getting the event time (using TEXTSPLIT and wildcard XLOOKUP)
28:36 - Removing duplicate records with UNIQUE function

🧹 More videos on Data Cleaning:

Data Cleaning in Excel - 10 Amazing Tricks - youtu.be/q7EpoOwBcnM (400k views, must watch)
Data Cleaning in Excel - 10 PRO tricks - youtu.be/SNVjndgWBlw (500k views, must watch)
How to clean, analyse and visualize data - youtu.be/H6k28jhclwI (450k views, long-form)
Power Query in 15 mins - youtu.be/UAFExySaSPY (450k views, must watch)
Power Query in 30 mins - youtu.be/MMdcczmULrU (200k views, NEW)
Power Query Masterclass - youtu.be/PiFAa_jjaEI (700k views, long-form)

🧑‍💻 Complete Adv. Excel Course:

Want to learn formulas, Power Query, charting, pivot tables, Power Pivot, DAX, dashboards and advanced features - all in one place?
Check out my Excel School program. You will love it.

💥Course: chandoo.org/wp/excel-school-program
💰Discount: use code 10101010 to get 10% discount

~

#excel #datacleaning #function
Top 10 Excel Functions for Data CleaningHow to make an Excel Dashboard in 5 Easy Steps (Interactive + Free File)I got braces in my 40s!Excel SUBTOTAL Magic 🪄Learn Data Modelling & Star Schema for Power BI in 20 minutesHR Data Analytics & Awesome Dashboard with Power BI 💡: End-to-End ProjectPower BI got a MAJOR upgrade - This changes everything!How to pick the perfect chart for your situation in Power BI?WRAPROWS in Excel - a must have functionPower BI Jargon Buster - 25 More Buzzwords explained in 15 minutesThis Excel Formula Shows Stock Prices Instantly!Complete Excel Tutorial for Data Analysis in 4 Hours (with FREE Files)
Chandoo |

Top 10 Excel Functions for Data Cleaning

SHARE TO X SHARE TO REDDIT SHARE TO FACEBOOK WALLPAPER