Profile

Join date: Dec 18, 2019
Posts
Dec 6, 2022 ∙ 2 min
Auto-replace Text in Excel Cell with VBA
In recent posts, I’ve been talking about validating your Excel data using VBA. I talked about creating a validation harness, which you...
1
0
Dec 2, 2022 ∙ 4 min
Validating Numeric Fields in Excel
Use Excel's Data Validation feature, in conjunction with Excel functions, to validate numeric data.
5
0
Dec 1, 2022 ∙ 5 min
Using Access to Clean Excel Data, Part 3
Use MS Access to clean numeric fields that contain text.
2
0

Kimberlee Martin

Admin
More actions