MS Word is an essential software to make quality documents, reports, and so on. Often we need to present an overview along with statistics. In these cases, the use of MS Excel is inevitable. But the issue is, when we copy the data or table containing text from MS Excel to MS Word, we observe the formatted table along with the text almost all the time. In some cases, the table is unnecessary. Perhaps, we need to copy only text from MS Excel to MS Word. But copying only texts is not everyone’s mug of tea. In this article, we will learn several handy methods to copy only text from MS Excel to MS Word.
📁 Download Excel File
To practice please download the Excel file from here:
Learn to Copy Text Only from Excel to Word with 4 Approaches
Learn to copy text only from MS Excel to MS Word files with 4 catchy approaches. Following that we consider a dataset named Final Score of House of The Dragons containing Performer, Team Code, and Point heading where performers are divided into two teams called Targaryen and Hightower. In addition, the dataset has 4 columns as well as 11 rows. In this article, we are going to copy texts from the Excel dataset as well as the Excel table to a Word file. So let’s get started.
1. Utilize Paste Options to Copy Text from Excel to Word Without Table
By copying the dataset and using the Paste option in a Word file, one can easily copy text only from Excel to Word. Please check out the following steps.
⬇️⬇️ STEPS ⬇️⬇️
- Firstly, select the entire data B5:D11.
- Secondly, copy the data by pressing Ctrl+C altogether.
- Thirdly, Open a Word file and Right-Click on the Mouse to get a Context Menu list.
- After that, select the Keep Text Only option from the Paste option of the Context Menu list.
- Therefore, only texts appear without a table from an Excel file to a Word file.
2. Apply Convert to Text Feature
Converting the dataset into a table, one can easily import data into a word file from Excel using the Convert to Text feature from the Layout menu. Please follow the below steps.
⬇️⬇️ STEPS ⬇️⬇️
- Primarily, to make a table select the entire data B5:D11 first.
- Then, select the Table feature from the Insert menu of Top Ribbon.
- Thus, a box named Create Table appears including the $B$5:$D$11 range.
- Then, hit the OK button to proceed.
- Now, select the entire table.
- After that, Press Ctrl+C to copy the table.
- Since we are determined to copy text to a word file; So open a Word file and Press Ctrl+V to paste the table.
- Now a table is observed in the Word.
- From the Layout menu of the Top Ribbon, select the Convert to Text feature from the drop-down list of the Data section.
- However, a box named Convert Table to Text appears.
- Then, Select Tabs from the box and hit the OK button.
- Finally, we observe all the texts without tables or any formatting.
3. Use Paste Special Option Copy Text from Excel to Word Without Formatting
Copying the dataset, One can easily convert text to a Word file by using the Paste Special option. Please check the necessary steps below.
⬇️⬇️ STEPS ⬇️⬇️
- Initially, select the data B5:D11 range.
- Secondly, copy the data range by pressing Ctrl+C altogether.
- Thirdly, opening the Word file, navigate to the Paste option from the Home tab of the Top Ribbon.
- Then, select the Paste Special Option from the drop-down lists of Paste Options.
- Thus, a box named Paste Special appears.
- Next, Selecting the Paste option, choose Unformatted Text from the lists.
- Further, hit the OK button to paste the text only.
- Therefore, unformatted text observes in the Word file.
4. Copy from Excel Table to Word as Plain Text
Copying from Excel brings a table along with the text. To get only texts from an Excel Table to a Word file, please check out the below steps.
⬇️⬇️ STEPS ⬇️⬇️
- First, select the entire table.
- Then, Press Ctrl+C to copy the table.
- Next, Go to the Home tab and select the Keep Text Only option from the Paste Options list.
- In the end, we achieve the plain text only from Excel Table to a Word file.
📄 Important Notes
🖊️ Data may change during copying from MS Excel and pasting it directly to MS Word without following the above-mentioned methods.
🖊️ While copying the text from Excel, making an Excel Table is not important.
📝 Takeaway from This Article
📌 Paste Option feature of MS Word to copy texts from MS Excel datasets as well as Excel tables.
📌 Use of the Convert to Text feature of MS word to convert into the formatted text from MS Excel.
📌 Dynamic use of Paste Special option to copy Text from MS Excel to MS Word.
In this article, we learn to copy text only from Excel to MS Word. I hope you enjoyed your learning. Any suggestions, as well as queries, are appreciated. Don’t hesitate to leave your thoughts in the comment section. For better understanding and new knowledge, don’t forget to visit www.ExcelDen.com.