The task of converting a table created in the Excel application into a text document quite often arises before the user of the Microsoft Word office suite. The solution to the problem does not imply hacking skills or the use of additional software.
Instructions
Step 1
Press the "Start" button to open the main menu of the Windows operating system and open the "All Programs" section to carry out the procedure for converting the selected table into a text document format.
Step 2
Expand Microsoft Office and start Excel and Word.
Step 3
Open the table to be converted in Excel and select the desired part or all of the table.
Step 4
Expand the "Table" menu in the top toolbar of the application window and select the "Convert" command (for Microsoft Word 2003 version).
Step 5
Use the "Table to Text" option in the drop-down menu and apply the checkbox to the desired separator field in the dialog box that opens. It should be remembered that when you select the "Paragraph Mark" option, the data of the converted table will be separated by paragraphs, and the "Tab Mark" option will allow you to convert the table into a single section. Use the spacebar or hyphen key when selecting the Other option.
Step 6
Confirm the application of the selected changes by clicking OK (for Microsoft Office version 2003).
Step 7
Select the rows of the required table to be converted into text format, or the entire table, and open its context menu by clicking the right mouse button (for Microsoft Office 2007 version).
Step 8
Select the "Layout" item and select the "Data" command from the expanded submenu.
Step 9
Use the "Convert to Text" option and apply the checkbox to the desired separator field in the dialog box that opens. Confirm the application of the selected changes by clicking the OK button (for Microsoft Word version 2007).
Step 10
Select the selected table and click the Edit menu in the top toolbar of the Excel 2010 window.
Step 11
Use the Copy command to save the table to the clipboard and switch to Word.
Step 12
Select the location to save the text document you are creating and open the Edit menu on the top toolbar of Word 2010.
Step 13
Select "Paste Special" and use the "Microsoft Excel Sheet (Object)" option.
Step 14
Confirm the application of the selected changes by clicking OK (for Microsoft Office version 2010).
