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:


and your problem will be solved.


6 key areas of change for accountants and auditors

New accounting standards on revenue recognition, leases, and credit losses present implementation challenges. This independently-written report identifies the hurdles that accounting professionals face and provides tips for overcoming the challenges.


How tax reform will impact individual taxpayers

Amy Wang, a CPA who is a senior technical manager for tax advocacy at the AICPA, answers to some of the most common questions on how the new tax reform law will impact individual taxpayers.