Use the SUBSTITUTE() function to remove non-printable characters in Excel. Excel offers a CODE() function which returns the ASCII code for a given character. This is basically the reverse of the ...

Excel's Trim function will remove all but one space between words; ... (ASCII character 160) in cell "A1" with standard spaces (ASCII character 32) and then trims leading, ...