Kimberlee MartinNov 28, 20226 minParse Phone and Extension with VBALast week, I wrote a blog post about creating a validation harness in Excel VBA. I laid out a structure you can add to your Excel file...
Kimberlee MartinNov 23, 20226 minValidate Phone Numbers in ExcelUse Excel's formatting and data validation features to validate phone numbers
Kimberlee MartinNov 21, 20226 minUsing Access to Clean Excel Data, Part 2Use MS Access to clean phone numbers in your Excel data.
Kimberlee MartinNov 18, 20229 minValidation Harness in Excel VBAAdding a Visual Basic structure to your Excel file for validating data.
Kimberlee MartinNov 16, 20226 minValidating a State in ExcelUse Excel tools to validate a U.S. state.
Kimberlee MartinNov 14, 20225 minUsing Access to Clean Excel Data, Part 1Excel data can be messy. Use MS Access features to clean it up.
Kimberlee MartinNov 7, 20223 minDebugging VBA without Line NumbersI wrote a post several years ago about adding line numbers to your VBA code. To this day, it remains my post popular post ever. Why? It’s...
Kimberlee MartinNov 4, 20227 minAppending Excel Data to an Access TableUse an append query to add Excel data to an Access table