I got help in getting a data cleaning script written to help remove unwanted spaces and characters in my source data. It works pretty well but I have noticed that it has missed catching some blank spaces. Any idea on why? Prouduction-IM-METRICS-T-V01.5.xlsm
Please identify an example cell that has the problem.
To remove non-breaking spaces you could modify the "=TRIM" line in your CleanData macro
Open in new window