We are going to get a new skill again! That’s CLEAN Function. What is the CLEAN Function and how to use it? This tutorial will answer these questions.

The CLEAN function helps you remove all unprintable characters from text.

The CLEAN function can remove the first 32 non-printed characters of 7-bit ASCII code (numeric codes 0 to 31), which typically appear at the beginning and end of text imported from other applications.

Syntax

=CLEAN(text)

How to use it?bounce house for sale

Enter =CLEAN(A2) in cell B2 and press Enter.

That’s it.