If you want to remove all non-printable characters as well as the non-breaking spaces from a text string, you need to use the CLEAN() function, the SUBSTITUTE() function, and the TRIM() function ...

It's easy to remove all whitespace from a string, but you'll typically want ... without the quotes replaces non-breaking spaces (ASCII character 160) in cell "A1" with standard spaces (ASCII ...