Microsoft Office Online
Sign in to My Office Online (What's this?) | Sign in

Warning: You are viewing this page with an unsupported Web browser. This Web site works best with Microsoft Internet Explorer 6.0 or later, Firefox 1.5, or Netscape Navigator 8.0 or later. Learn more about supported browsers.

Email this linkEmail this link Printer-Friendly VersionPrinter-Friendly Version Bookmark and ShareShare
Convert text to a table or vice versa
 

Do one of the following:

ShowConvert text to a table

When you convert text to a table (table: One or more rows of cells commonly used to display numbers and other items for quick reference and analysis. Items in a table are organized into rows and columns.), you separate text with a comma, tab, or other separator character (separator characters: Characters you choose to indicate where you want text to separate when you convert a table to text, or where you want new rows or columns to begin when you convert text to a table.) to indicate where a new column should begin. Use a paragraph mark to begin a new row.

  1. Indicate where you want to divide text into columns by inserting the separator characters you want.

    For example, in a list with two words on a line, insert a comma or a tab after the first word to create a two-column table.

  2. Select the text you want to convert.
  3. On the Table menu, point to Convert, and then click Text to Table.
  4. Under Separate text at, click the option for the separator character you want.

    Select any other options you want.

© 2009 Microsoft Corporation. All rights reserved.