4 Easy Ways to Copy Text Only From Excel to Word

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.

Dataset of How to Copy Text Only From Excel to Word.

method

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.

Copy the dataset from Excel to paste Text Only to Word.

  • 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.

Text-only paste option to copy text to Word from Excel.

  • Therefore, only texts appear without a table from an Excel file to a Word file.

Text copied into the Word file.

method

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.

Converting the dataset into a table to copy only text from Excel to Word.

  • Thus, a box named Create Table appears including the $B$5:$D$11 range.
  • Then, hit the OK button to proceed.

Create table box to convert the dataset into a table.

  • Now, select the entire table.
  • After that, Press Ctrl+C to copy the table.

Copying the table to extract text to a Word file.

  • 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.

Convert to Text option to insert the text only without a table.

  • However, a box named Convert Table to Text appears.
  • Then, Select Tabs from the box and hit the OK button.

Convert Table to Text box to convert the entire table into a simple dataset.

  • Finally, we observe all the texts without tables or any formatting.

Table converted into Formatted text in Word.

method

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.

Copying the dataset to insert into a Word file.

  • 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.

Use of the Paste Special option to paste the copied data into Word.

  • 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.

Unformatted Text option selection from the Paste Special box.

  • Therefore, unformatted text observes in the Word file.

Text copied from Excel to Word.

method

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.

Copying the table.

  • Next, Go to the Home tab and select the Keep Text Only option from the Paste Options list.

Selecting the Text only option from the Paste feature.

  • In the end, we achieve the plain text only from Excel Table to a Word file.

Unformatted text inserted into Word from Excel 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.


Conclusion

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.

(Visited 41 times, 1 visits today)
MD Tanvir Rahman

MD Tanvir Rahman

Hello, I am Tanvir. Graduated from BUET. Had a year-long Experience at Operation of Vitacan Industries Ltd. I found Excel is the most unique software to reduce both time and paper. Now, I am an Excel enthusiast, love to play with data and publish content.

We will be happy to hear your thoughts

Leave a reply

ExcelDen
Logo