Macro to remove characters
I have an Excel Workbook where the sheets are all linked to one main sheet.
The data on the main sheet ends up with character10 (the little square box)
in each cell.
I have a macro that I run and it deletes all the characters for me, its
great I love it, but it also deletes all the formulas on that sheet which I
need.
How can I delete that character without deleting my formulas.
|