Sometimes, your data contains some characters which make some portion of your data unusable. Below is a macro which cleans your worksheet in the following way -
- It will remove non-printable characters with ASCII codes 0 to 31.
- It will remove leading and trailing blanks.
- Will remove characters with ASCII codes 127, 129, 141, 143, 144, 157, 160.