Convert Text to a Table
[Pages:2]Let Me Try!
Convert Text to a Table
Before you begin...
Ensure that you have downloaded the data set. To do so, open your course homepage. Click on the link: Click here to download the dataset for this course. Save the dataset to the C: / drive on your computer. In this exercise, you will convert text currently in tabular columns into a table. Then you will convert the table back to regular text.
1. Open the file WD05-D03-StdntTables from your course dataset. 2. Scroll to page 3 and select all the rows, including the Second Semester Schedule heading. 3. Choose InsertTablesTable , and choose Convert Text to Table. 4. Follow these steps to create a table from the selected text:
The text is now in a five-column table. Don't worry about the heading being in one cell. You'll fix that a little later.
Let Me Try!
Convert a Table to Text
5. Click in any table cell.
Notice the two new Table Tools tabs, Design and Layout, have been added to the Ribbon. These are contextual tabs, meaning they appear in context with what you are working on, in this case, when the insertion point is in a table.
6. Choose Table ToolsLayoutDataConvert to Text Tabs is chosen and click OK. The table is converted back to a tabular table.
. When the dialog box appears, verify that
7. Click Undo
to return the text to table format.
8. Save and close the file.
................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related download
- convert text to columns wilmington university
- convert text to a table
- how to export a distribution list in outlook to excel
- featurizing text converting text into predictors for
- an introduction to version 12 planning engineer est
- outreg help pages kellogg school of management
- microsoft excel green belt training read only ohio
- ultimate suite for excel comprehensive set of time saving
- working with tables libreoffice
- 102 useful excel formulas cheat sheet pdf free download
Related searches
- excel formula to convert text to number
- excel convert text to value
- convert text to song
- convert text to audio online
- convert text to wav
- convert text to pdf online free
- convert text to voice mp3
- convert text to voice mp3 offline
- excel vba convert text to number
- vba convert text to numeric
- excel convert text to integer
- how to convert text to number