Take a Guess to Win Windows 10 Pro Key!
previous arrow
next arrow
Slider

How to Use the CLEAN Function in Excel?

Date:2022-1-22 Author:Sandra

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?

How to Use the CLEAN Function in Excel?

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

How to Use the CLEAN Function in Excel?

That’s it.

Copyright Statement: Regarding all of the posts by this website, any copy or use shall get the written permission or authorization from Myofficetricks.

Leave a Reply

Your email address will not be published. Required fields are marked *