CLEAN function. Delete unprintable characters.(Microsoft Excel)
This function returns a string that has had line feeds in cells, tab characters, and control characters that were included when imported from other applications or operating systems removed.
How it works
=CLEAN(text)
| Name | Omission | Explanation |
|---|---|---|
| text | Required argument. | Specify the target string. |
Demonstrate
The following is an example of executing the deletion of a newline and TAB character.
Since the TAB character is not visible in Excel, the number of characters is checked with the LEN function.
Spill
Spill if the parameter is a cell range.
---