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?

#1070038
SalenaKnight
Member
  • Total posts: 604
Up
0
::
HBTRADE, post: 88241 wrote:
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.

Thanks HBtrade – I’ve book marked this post for future reference and will have a go at your suggestion as well.

Thanks again to everyone.