Excel CLEAN Function
How to use the CLEAN Function
This Excel tutorial explains how to use the Excel CLEAN function with syntax and examples.
SUMMARY:
The Excel CLEAN function use to removes all nonprintable characters from a text or text string, It removed the nonprintable text or any line break from the beginning or end of the input text string.
For example,
- The formula =CLEAN(" Hi Jack") would return "Hi Jack"
- The formula =CLEAN("Hi Tim"& CHAR(10)) would return "Hi Tim"
PURPOSE:
To removes all nonprintable characters.
RETURN VALUE:
The CLEAN function returns text String.
SYNTAX:
=CLEAN(text)
ARGUMENTS:
The CLEAN function syntax has the following arguments:
- text: Required. Any text or text string from which you want to remove non-printable characters.
REMARKS:
- It remove all non-printable character from beginning, end or in between the text string.
Diffrent way to use the CLEAN function...
