Get Excel To Print All Data


Q. I import loads of spreadsheet data from customers and suppliers which I include in my Excel reports. So far so good. But when I print the reports, some of the information doesn’t show. Can you help?

A. You’re not alone, and luckily there’s a simple solution. Many old mainframe spreadsheet programs and online services use nonprintable codes for some of their data. When those files are sent to others, the codes supporting those data won’t print. Excel has a worksheet function that can “clean” the text by removing the nonprintable characters and control codes. Use the following syntax:

=CLEAN(text)

and your problem will be solved.

SPONSORED REPORT

CPEOs provide peace of mind around payroll services

The creation of these new IRS-certified service providers for small businesses clarifies some issues around traditional professional employer organizations.

QUIZ

Pronoun practice to help polish your prose

Using pronouns correctly in writing and speech can help you make a good impression. Try our 10-question quiz.