I Built a Self-Cleaning Excel Spreadsheet

Stop cleaning Excel data manually.

In this video, you'll learn how to build a fully automated Excel data cleaning system using modern Excel formulas. Using FILTER, REGEXREPLACE, REGEXEXTRACT, REGEXTEST, HSTACK, VALUE, and Dynamic Arrays, you'll create a reusable workflow that automatically cleans names, phone numbers, email addresses, reference IDs, and currency values every time you paste in a new export.

No VBA. No Power Query. No manual cleanup.

Whether you're a business analyst, accountant, finance professional, operations manager, data analyst, or Excel power user, this technique can save hours of repetitive work and help you build scalable, maintainable Excel solutions.

📂 DOWNLOADS

📥 Download the follow-along workbook:
https://docs.google.com/spreadsheets/d/1XISE6VyRcRww3tuQjxzl20Ty9iFdrv1S/edit?usp=sharing&ouid=101795986641981235103&rtpof=true&sd=true

⚠️ IMPORTANT

Please download the workbook from Google Drive and open it in Microsoft Excel Desktop (Microsoft 365).

This tutorial uses modern Excel functions including FILTER, REGEXREPLACE, REGEXEXTRACT, REGEXTEST, VALUE, HSTACK, and Dynamic Arrays. These functions are not fully supported in Google Sheets and may return errors or behave differently if opened in a browser.

📺 MODERN EXCEL FORMULAS PLAYLIST

Watch the full Modern Excel Formulas series:
https://www.youtube.com/playlist?list=PLM0-IlSKnvQY

📌 TIMESTAMPS

00:00 Automate Excel Data Cleaning
00:28 Future-Proof Your Data with Excel Tables
00:53 Remove Blank Rows with FILTER
01:22 Exclude Test Records Automatically
01:43 Clean Messy Text Using REGEXREPLACE
02:27 Reuse Regex Logic Across Columns
02:45 Extract Phone Numbers from Mixed Text
03:21 Extract Email Addresses with REGEXEXTRACT
04:00 Extract Reference IDs Automatically
04:33 Extract Currency and Deal Values
04:53 Validate Email Addresses with REGEXTEST
05:23 Convert Text Back into Numbers with VALUE
05:42 Build an Automated Paste-and-Clean Workflow
06:04 Create One Master Formula with HSTACK

💡 WHAT YOU'LL LEARN

• Excel data cleaning automation
• How to use FILTER to remove blank rows and unwanted records
• How to clean inconsistent text using REGEXREPLACE
• How to extract phone numbers, email addresses, IDs, and currency values using REGEX
• How to validate data using REGEXTEST
• How to convert text back into usable numbers with VALUE
• How to combine multiple calculations into a single formula using HSTACK
• How to build a reusable Excel workflow that automatically processes future exports

🛠 FUNCTIONS USED

• FILTER
• REGEXREPLACE
• REGEXEXTRACT
• REGEXTEST
• VALUE
• HSTACK
• SORT
• IFERROR
• ISERROR
• SEARCH
• Excel Tables
• Dynamic Arrays

🚀 PART OF THE MODERN EXCEL FORMULAS SERIES

This video is part of the Modern Excel Formulas series, where you'll learn practical techniques to automate repetitive tasks, clean data faster, build smarter reports, create dashboards, and take advantage of the newest Excel features available in Microsoft 365.

If this video helped you, consider subscribing for more Excel automation, reporting, dashboard, data cleaning, AI-powered workflow, and modern Excel tutorials.

💬 Which modern Excel function would you like to see covered next? Let me know in the comments.

#Excel
#ExcelAutomation
#DataCleaning
#ExcelTips
#ModernExcel

Excel data cleaning tutorial, Excel automation tutorial, Excel REGEX tutorial, Excel REGEXREPLACE, Excel REGEXEXTRACT, Excel REGEXTEST, Excel FILTER function, Excel HSTACK, Excel Dynamic Arrays, Excel 365, Modern Excel formulas, Excel productivity, spreadsheet automation, Excel text extraction, Excel data preparation, advanced Excel, Excel for analysts, business analyst Excel, automate Excel workflows, clean Excel exports automatically.

Видео I Built a Self-Cleaning Excel Spreadsheet канала StraightOuttaKapston