Clean Up Data Imported To Excel

BY STANLEY ZAROWIN

Q. When I import data to a worksheet, I sometimes see a bunch of small rectangles in the cells. Although they don’t seem to affect the calculations, I can’t clean them out. Any ideas?

A. What you’re seeing are nonprinting characters. You’re right; they don’t affect the data but they do look messy. Use Excel’s CLEAN function to get rid of them.

If the nonprinting character is in cell A1, go to its adjacent cell, B1, and type CLEAN (A1) and press Enter. Cell B1 will then display the text or data without the nonprinting characters.

RESOURCES

Keeping you informed and prepared amid the coronavirus crisis

We’re gathering the latest news stories along with relevant columns, tips, podcasts, and videos on this page, along with curated items from our archives to help with uncertainty and disruption.

SPONSORED

Building process maps: Template and instructions

Documenting your financial close process and finding opportunities for automation are more important than ever. Our customizable slide deck has instructions, a risk assessment questionnaire, and bonus checklists that will help you map out your process.