Kimberlee MartinDec 6, 20222 minAuto-replace Text in Excel Cell with VBAIn recent posts, I’ve been talking about validating your Excel data using VBA. I talked about creating a validation harness, which you...
Kimberlee MartinDec 2, 20224 minValidating Numeric Fields in ExcelUse Excel's Data Validation feature, in conjunction with Excel functions, to validate numeric data.
Kimberlee MartinDec 1, 20225 minUsing Access to Clean Excel Data, Part 3Use MS Access to clean numeric fields that contain text.
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...