Parse Phone and Extension with VBA
Last 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...
top of page
Search
Kimberlee Martin
Nov 23, 20226 min read
Validate Phone Numbers in Excel
Use Excel's formatting and data validation features to validate phone numbers
25 views0 comments
Kimberlee Martin
Nov 21, 20226 min read
Using Access to Clean Excel Data, Part 2
Use MS Access to clean phone numbers in your Excel data.
21 views0 comments
Kimberlee Martin
Nov 18, 20229 min read
Validation Harness in Excel VBA
Adding a Visual Basic structure to your Excel file for validating data.
26 views0 comments
Kimberlee Martin
Nov 16, 20226 min read
Validating a State in Excel
Use Excel tools to validate a U.S. state.
25 views0 comments
Kimberlee Martin
Nov 14, 20225 min read
Using Access to Clean Excel Data, Part 1
Excel data can be messy. Use MS Access features to clean it up.
30 views0 comments
Kimberlee Martin
Nov 7, 20223 min read
Debugging VBA without Line Numbers
I 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...
9 views0 comments
Kimberlee Martin
Nov 4, 20227 min read
Appending Excel Data to an Access Table
Use an append query to add Excel data to an Access table
26 views0 comments
CATEGORY
ARCHIVE
bottom of page