Clean Your Text in Excel


There is an interesting function in Excel worksheets. I know that you are most likely thinking – well most of them are pretty interesting, but this particular function is interesting in that it makes sure that your text is clean. What do I mean by clean? Well it means that Excel makes sure that your text contains only printable characters and will remove certain non-printable characters and control codes that may be contained in the text in your worksheet.

The function syntax is pretty simple as you can see below:

=CLEAN (text)

You simply include the text or a reference to a cell that contains text.

Hmmm… you might ask why would you even clean your text?

Well if you import information from the Internet or some server other than your own, the non-printable characters could come along with whatever you have copied, which can cause you problems when you are attempting to view or print the information.


It’s always good to be clean right?

About the Author

Carol Bratt

Carol holds A+, MCP, and MOS computer certifications and is the resident DCT Office expert. She trains the staffs of small law firms in the use of Microsoft Office applications and has authored many books covering Microsoft Office as well as written articles for Infopackets, TechnoLawyer, and Digital Harbor. For more Microsoft Office tips visit Carol's Corner Office or follow Carol on FaceBook and Twitter.

There is one comment

Comments are closed.