Try using the CLEAN function.

Go to a blank sheet. In cell A1 enter "=clean(" then point to cell A1 in the main sheet, then enter ")" . copy the formula and make sure it does what you want. Then Edit\copy the lot, and edit\paste special\values

Matt