CLEAN

Removes non-printable characters.

Excel: Not checked yet
Google Sheets: Not checked yet
Returns: Text

Examples

=CLEAN("text")

Result text

Syntax

CLEAN(text)

text: text required

ASCConverts full-width characters to half-width. BAHTTEXTSpells a number as thai baht and satang. CHARReturns the character for a character-set code. CODENumeric code of the first character. CONCATJoins multiple text strings into one. CONCATENATEJoins several text strings into one.