Text to Table in Word

On the Net for almost 2 years...helping folks all over the world! Download it today!

Download my Free Email Primer today!

Navigation

Site Home
Up
Site Map
The Library
The Bookstore
The Classroom
The Show Room
SMP Services
Our Newsletter!
Site Updates
The Break Room
Article Submission
Company Info
 

Converting Text to a Table in Word

Microsoft Word is a very versatile word processing tool. There are many features in the program of which many folks are not aware. With just a few clicks and some specially formatted text, items like tables of contents, indexes and bibliographies can be created and updated automatically. This is very useful, especially if you are writing long documents.

Another feature, which is very useful, is the conversion of text to tables and tables to text. If you are like me, it is sometimes hard to get everything to line up correctly using tab stops. There is a very easy shortcut to doing just that. Let's take a look at turning text into a table.

CONVERTING TEXT INTO A TABLE

Using a table can be a very effective way to display information, especially related data items. For an example, let us take a look at some fictional high school football statistics. There will be several categories of information, which will make up the headings for our table of statistics. We will want to show the name of the teams, their win records, their loss records, and their tied game records.

If you would like to try this out as you read along, start by opening up Word to a new document. Now, copy and paste
the following into the new document: Team Name, Wins, Losses, Ties, Bulldogs, 10, 1, 0, Indians, 5, 5, 2, Tigers, 6,, 4, Cowboys, 3,7,1, Mustangs, 4, 4, 2

Notice a few things here. A comma separates each data item. This will be used in formatting the table. Another thing to
note (which you might have thought was an error) is the double comma after the 6 following the team name "Tigers".
This is not an error, it is a place holder. If you don't have a value for a data item, place the comma there anyway, it will hold the place for that item.

Here is our information in comma separated form...notice the 2 commas  after the 6.

Now the fun begins. After you have pasted the line above into a new Word document, highlight all the text. Then select "Table" from the menu bar, scroll down to "convert text to table" and click it. A dialog box will pop up, asking for some formatting information. It will also have some default values shown. The first box will ask you for the number of columns you want. It will default to the number of entries in the list, in this case 24. Change text box value to 4, as this is the number of headings we want (Team Name, Wins, Losses, and Ties).

Select all the text, then go to "Tool", then "Convert Text to Table".

This box is where you set up the formatting of your table.

Leave the other settings at their default for now. The column width can be changed, but leave it at "Auto" for now. Since we are using commas for entry separators, check that radio button if it is not already. Click on the "OK" button and your comma separated text values will be transformed into a neat and tidy table!

Notice that the extra comma we talked about has been converted into an empty cell in the table. If we didn't have that extra comma, all the entries after that would be in the wrong column.

Absolutely Amazing! Your comma separated values are now a neat looking table!!

If you want to get really fancy, click on the autoformat button in the table format dialog box before you click "OK". You will be able to select from a variety of formats there, from simple grids to tables with color and fancy borders. If you would like to learn how to turn a table into  tabulated text, check out this tutorial!

Back to the Classroom Table of Contents

Back ] Site Home ] Up ] Next ]

Copyright 1996-2003 Steve Maurer, Steve Maurer Publications
Email us - steve@maurer.net
Phone -  (479) 582-5814
Fayetteville, Arkansas

http://www.steve.maurer.net

Bobby Approved