Match Pasted Text To The Format Of Target Document

BY STANLEY ZAROWIN

Q. When I copy text from a document or an e-mail that’s formatted in some unusual way and then I paste it into another document I’m faced with the problem of having to reformat it. Is there a simple way to do this?

A. The easiest way I know is to copy the text in the usual way (highlight it and then press Ctrl+C). But then, instead of just pasting it into the new document, click on Edit in the toolbar and then on Paste Special , which brings up this screen:

Then click on Unformatted Text and OK .

SPONSORED REPORT

Keeping client information safe in an age of scams and security threats

A look at the Dirty Dozen tax scams and ways to protect taxpayer information.

TECHNOLOGY Q&A

How to create maps in Excel 2016

Microsoft Excel 2016 has two new mapping capabilities. J. Carlton Collins, CPA, demonstrates how to make masterful 2D and 3D maps in Excel 2016.

QUIZ

News quiz: IRS enforcement, a hot job, and audit value

The IRS’s 2016 Data Book, a “hot job” of particular interest at this time of year, and insight into how executive and audit committees view the insights from financial statement audits received attention recently. See how much you know with this short quiz.