CLEAN function. Delete unprintable characters.(Microsoft Excel)

Japanese version.

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

textRequired 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.



Microsoft Excel Functions Text