Home – New Forums Other discussions Can anyone help me ‘clean up’ an Excel spreadsheet? Reply To: Can anyone help me ‘clean up’ an Excel spreadsheet?

#1070037
HBTRADE
Member
  • Total posts: 125
Up
0
::

I saved it a a CSV, closed & re-opened it in Excel.
In this case, there was a ÿ character in the $ column.
select such a cell, then in the address bar copy 1 x ÿ
find and replace ÿ with
save as xls or xlsx depending on your version.
saving as csv only works with single page workbooks, so work with a copy & do 1 page at a time.

have fun.