Scrub your data in VBA using Regular Expressions (RegExp).
A Regular Expression is a sequence of characters that create a pattern. The sequence could be something complicated like
<([A-Z][A-Z0-9]*)\b[^>]*<(.*?) to something simple like
Regular Expressions are very useful in VBA for working with many different scenarios of strings and introducing automation for transforming your data before loading to target databases for OLAP such as Essbase, Power Pivot or SSAS.