WD2000: How to Convert Data in One Column to a Table

• Microsoft Word 2000

SUMMARY

When you use Word to merge documents, data cannot be located in a single column, as in the following example:

Peter Kelly
123 Main Street
Anytown, US 12345

Judy Lew
Microsoft
456 Elm Street
Sometown, US 67890

   Name         Company     Address           City/State     ZIP_Code
   Peter Kelly              123 Main Street   Anytown, US    12345
   Judy Lew     Microsoft   456 Elm Street    Sometown, US   67890 

MORE INFORMATION

Data Documents Created in Other Programs

WordPerfect Data Documents

Q211702 WD2000: How to Convert WordPerfect Merge Data

Convert Text to Table in Word

1. Save the file containing the list of names with a different file name. Modify the version of the file with the new name (this way, if you make a mistake, you can start over with your original document).



2. Rearrange the names in the file. The following steps require that each address is separated with a blank line (see the example in the "Summary" section at the beginning of this article).
   
   NOTE: This method creates a separate field for each line in each address. If you want the information separated further than this, you must press the TAB key at the appropriate points. For example, if you have typed a first name and last name on the same line, the method below creates one field that contains both first and last names. If you want the first and last names to be in separate fields, you must place the insertion point between each first and last name and press the TAB key.
   
   Also, this method puts the lines into the first available field for each record, so if the records do not have the same number of lines, shorter records end up with information in different fields than the longer records. If you want to perform conditional merges, in which a certain type of information is expected in certain fields, you need to edit the data file after you create the table.



• Part 1: Remove Blank Lines Between Records Using the Following Steps:



1. On the Edit menu, click Replace.



2. Click in the Find what box.



3. Click Special, and select Paragraph Mark. (NOTE: If you don't see the Special button, click More to expand the dialog box.) Do this again, so that the Find what box shows "^p^p" (without the quotation marks).



4. If the No Formatting button is available (not dimmed), click this button to remove any additional Find formatting criteria.



5. Click in the Replace with box.



6. Type %%% (three percentage signs).



7. If the No Formatting button is available (not dimmed), click this button to remove any additional Replace formatting criteria.



8. Click Replace All.
   
   The document now shows the beginning of each record next to the end of the preceding record, separated by three percentage symbols:




Peter Kelly
123 Main Street
Anytown, US 12345%%%Judy Lew
Microsoft
456 Elm Street
Sometown, US 67890


• Part 2: Replace Paragraph Marks with Tab Characters Using the Following Steps:



1. Click in the Find what box, and delete the existing text.



2. Click the Special button and select Paragraph Mark.
   
   The Find what box now shows ^p.



3. Click in the Replace with box, and delete the existing text.



4. Click the Special button and select Tab Character.
   
   The Replace with box now shows ^t.



5. Click Replace All.
   
   The document shows all records in what appears to be one paragraph, similar to this:

   
      Peter Kelly  123 Main Street  Anytown, US  12345%%%Judy
      Lew         Microsoft        456 Elm Street   Sometown,
      US  67890 

   NOTE: This method produces one extra field when the final paragraph is replaced with a tab. You should delete this final tab.



• Part 3: Replace the Percentage Signs with Paragraph Marks Using the Following Steps:



1. Click in the Find what box, and delete the existing text. Type %%% (three percentage signs).



2. Click in the Replace with box, and delete the existing text.



3. Click Special and select Paragraph Mark. Click Replace All.



4. Click Close to close the Find and Replace dialog box. The text is now in the proper format to be converted to a table.



3. Select the text to be converted to a table.



4. On the Table menu, point to Convert, and then click Text to Table.



5. In the Separate Text At section, select Tabs.



6. Click OK. The data is now in a table.



7. Click in the first cell of the table. On the Table menu, point to Insert and then click Rows Above.



8. In the first row, type a one-word field name for each column.



9. On the File menu, click Save.
   
   NOTE: As previously mentioned, if the data for a specific field is in different columns, you need to move the data for those fields to one column. If a column becomes blank, delete it by following these steps:



1. Place the insertion point into the column.



2. On the Table menu, click Delete Columns.

Additional query words: howto grey convert percent

Keywords : kbdta kbmerge wd2000
Version : WINDOWS:2000
Platform : WINDOWS
Issue type : kbinfo