How to remove unwanted characters in Excel

Function TRIM (TRIM) removes all extra spaces from a string, if any. Function CLEAN (PRINT) removes all non-printable characters from a string.

  1. For example, a cell A1 in the figure below contains the string “Excel Easy” (with two spaces).

Note: Function TRIM (TRIM) returns the string “Excel Easy” (without the extra space).

  1. Cell A1 in the following figure contains a non-printable character.

Note: Function CLEAN (PRINT) removes this non-printable character. Non-printable characters may appear, for example, after importing text from other applications.

Leave a Reply