Removing ASCII & Non-Printing characters

I am using the following code to clean spreadsheets cell by cell:

HTML Code: 

Is there a way to apply this to an entire spreadsheet without having to do it cell by cell in a manner similar to this code (which doesnt clean the ASCII 160)?

HTML Code: 

Please Login or Register  to view this content.

Originally Posted by dagindi

I am using the following code to clean spreadsheets cell by cell:

HTML Code: 

Is there a way to apply this to an entire spreadsheet without having to do it cell by cell in a manner similar to this code (which doesnt clean the ASCII 160)?

Try

Please Login or Register  to view this content.