Checkout this introductory series detailing data cleanup workflows with the Power Query in MS Excel. Video 1: Introduction to Data Query– Standardize text formatting on select columns– Remove duplicate entries Video 2: Formatting Phone Numbers– How to remove unwanted characters– How clean ‘null’ entries– How to split a column by character count– How to createContinue reading “Excel Power Query for Data Cleanup”
Category Archives: Uncategorized
Data Cleanup with VBA in MS Excel
This is a sample workflow no how to cleanup data utilizing MS Visual Basic for Applications (VBA) tools in Excel. Download the working file from Github.
Birr-Data 