Journal of Accountancy Large Logo
|
Technology

Convert Tables to Text and Vice Versa

By Stanley Zarowin
December 2002
Q. Is there a way to convert a table in a Word file to just an array of numbers, which I find easier to work with?
A. Not only can you convert a table, but you can turn an array of text or numbers into a table. Word has a tool that does both—and it’s nicely automated with a wizard.

For example, let’s say you have this array of numbers and you want to change it into a table—it could just as well be a couple of words.

34, 54, 44, 90
22, 32, 56, 33

Highlight the array and click on Table, Convert, producing this screen.

When you click on Text to Table, this screen at right will appear:

Notice that it recognized you needed four columns. Make whatever adjustments you need and click on OK and you’ll produce this table:

34 54 44 90
22 32 56 33

When you convert a table to text, you’ll get this screen, giving the option of how you want the text elements separated—by paragraph marks, tabs, commas or something else:

View CommentsView Comments   |  
Add CommentsAdd Comment   |  

RELATED TOPICS

CPE Direct articles Web Exclusive content
AICPA Logo Copyright © 2009 American Institute of Certified Public Accountants. All rights reserved.
Reliable. Resourceful. Respected. (Tagline)