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 QUIZ

How well do you know small business?

There are over 30 million small businesses in the U.S., and many of them are optimistic in their outlook. Are you familiar with the obstacles and opportunities they are facing? Test your small business acumen with this quiz sponsored by Chase Ink®.

SPONSORED REPORT

In focus: Payroll

Providing payroll services that comply with ever-changing regulations and meet evolving employee and employer demands is no easy task. Paychex's Tom Hammond discusses common payroll considerations for CPA firms.