Table of Contents
About
CLEAN function in Excel can be used to remove the line breaks and other non-printable characters from a text string.
Function Type
Text
Purpose
Clean data by removing non-printable characters.
Return value
Text without non-printable characters.
Syntax
=CLEAN(text)
Arguments
text – text to be cleaned
Example
Notes
The CLEAN function removes the first 32 (non-printable) characters in the 7-bit ASCII code (values 0 through 31) from a text string.
Excel Functions in Alphabetical Order (Complete list)
Complete List of Excel Functions (Category wise)