I. Intro
The CLEAN function deletes non-printable characters in documents. When importing text from other apps, you can use CLEAN to remove characters that can't be printed using the current operating system.
II. About the function
- Formula: =CLEAN (ref_text)
- Parameters:
- Ref_text (required): The cell to be referenced.
- Note: The CLEAN function deletes non-printable characters from the reference cell.
III. Steps
Use the CLEAN function
- Select a cell and click Formulas on the toolbar, then select Text > CLEAN. You can also directly enter =CLEAN in a cell.
- Type the text you want to clean in the formula, or select a cell with text.
- Press Enter to display the results.
Note: Line breaks are deleted in this example because the character from the Enter key is regarded as non-printable.
250px|700px|reset
Delete the CLEAN function
Select the cell with the CLEAN function, and press Delete.
IV. Use case
HR: Change how a list is displayed
The CLEAN function can quickly convert a vertical list into a horizontal list for printing or presentation.
- Formula used below: =CLEAN(A2)
- About the parameters: The CLEAN function clears all the non-printable characters in A2 to create a list of names in a row.
250px|700px|reset