How to Remove Non-Printable Characters in Excel – Excel Tips and Tricks

How to Remove Non-Printable Characters in Excel – Excel Tips and Tricks

Learn how to remove non-printable characters.

When text that was imported from another program contains characters that your operating system might not be able to print, use CLEAN. For instance, CLEAN can be used to remove non-printable low-level computer code that is typically found at the start and end of data files.

The CLEAN function was designed to remove the first 32 nonprinting characters in the 7-bit ASCII code (values 0 through 31) from text. In the Unicode character set, there are additional nonprinting characters (values 127, 129, 141, 143, 144, and 157). By itself, the CLEAN function does not remove these additional nonprinting characters.

#microsoft #excel #exceltips #tips #exceltricks #tricksandtips

Close Menu