Excel CLEAN Formula | Techy Stuff | Scoop.it
Excel CLEAN Function will remove the non-printing characters typically brought in from other applications or web pages.

Via Kris