top of page
  • Writer's pictureDp

"Clean" Function In Excel

Updated: May 2, 2019

This function removes any nonprintable characters from text.

These nonprinting characters are often found in data which has been imported from other systems such as database imports from mainframes.

This will be useful when you convert a PDF to word and you get some non printable  characters




If you liked this tutorial, share it with your friends. And also you can follow us on Youtube, Twitter and Facebook. We would love to hear from you, Please do comment, suggest or compliment our work and we shall make it better for you.

You can write us at


Recent Posts

See All


bottom of page