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.

NEWS

IRS sets start date for tax season

The IRS announced that tax season will start in late January and that it will issue refunds to taxpayers despite the partial shutdown of the federal government.

PODCAST

Why CPAs can’t wait on automation tools

What do accounting firms waiting on others to develop AI, automation, and data analytics tools have in common with a baseball fan sitting in a stadium filling with water at an exponential rate? The answer could determine your firm’s fate.