View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
YanYan YanYan is offline
external usenet poster
 
Posts: 14
Default 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.