Excel Tip: Pasting Text into Excel 2010
Excel expert David Ringstrom is sharing his tips for optimizing the way you use Excel in our new Excel Tips series.
By David Ringstrom, CPA
From time to time, you might copy a list of data in text format from a webpage, report screen, or other source to the Windows clipboard. In such cases, Excel 2010 offers a hidden shortcut that makes it easier to break such data into columns.
With text data on the clipboard, click the lower half of the Paste button on the Home tab, and then choose Use Text Import Wizard.
This feature allows you to parse delimited data into columns based on a separator, such as tab, semicolon, comma, space, or a single character of your choice. Or, you can choose Fixed Width and manually place column breaks where you need them. This saves the step of pasting data into a worksheet column and then manually launching the Text to Columns wizard on the Data tab of the ribbon.
Voice of the Editor
Even though any accounting auditor would tell you it seems like there are an awful lot of tax accountants out there, surely one-third of the country isn't made up of tax preparers, so it's rather startling news to learn that one-third of Americans like to do their taxes. Who knew?
This Week on AccountingWEB
Bill Walter of Gross, Mendelsohn & Associates and Harold Gaar of TravisWolff LLP weigh in on mobile technology use while employees are at work.
WestArk RSVP and Fayette County Community Action Agency – organizations that received grant funding through the IRS Tax Counseling for the Elderly (TCE) program – spoke with AccountingWEB about how they assist senior citizens in their communities.
CPA Robert Raiola, who heads the Sports & Entertainment Group of Fazio, Mannuzza, Roche, Tankel, LaPilusa, LLC, talks NFL player income taxes with AccountingWEB.
Retiring KPMG Centennial Professor of Accounting at the University of Texas at Austin McCombs School of Business Robert May, PhD talks with AccountingWEB about his rewarding forty-three-year career.