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
|text||Required argument.||Specify the target string.|
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 if the parameter is a cell range.