How to Copy Only Text from Excel to Word (3 Quick Methods)

When you copy a data table from excel and paste it into Microsoft Word, you will find the data with the table from excel. Sometimes you may need only the data without the table to work. In this article, I am going to share with you some quick methods to copy only text from excel to word.


Download Practice Workbook

Download this practice workbook to exercise while you are reading this article.


3 Effective Methods to Copy Only Text from Excel to Word

In the following, I have shared 3 effective methods to explain this task.

Suppose we have a dataset of a shop containing kitchen goods and their stock availability in the shop. Now we will copy text from this excel dataset to the word book.


1. Use Paste Option Feature to Copy Only Text from Excel to Word

To copy the only text in a word book you can use the “Paste Option” to get quick results.

Steps:

  • Select the whole dataset and press Ctrl+C to copy.

Apply Paste Special Tool to Copy Only Text from Excel to Word

  • Open your word file and place the cursor at the place where you want to paste.
  • Placing the cursor click the right button on the mouse.
  • Select “Keep Text Only” from the “Paste Options”.

Apply Paste Special Tool to Copy Only Text from Excel to Word

  • Thus you can get your only text data copied from an excel file in a simple way.

Read More: How to Copy and Paste from Excel to Word Without Cells (2 Quick Ways)


2. Use Convert to Text Function to Copy Only Text from Excel to Word

Let’s get introduced to another simple method to transfer only text in word.

Suppose we have a dataset with an inserted table from the excel worksheet.

Steps:

  • Choose data from the dataset and press Ctrl+C to copy.

  • Paste the data into a word file.
  • From the word file, select the whole data by pressing the mark button from the following screenshot.
  • Go to Layout > Convert to Text.

Use Convert to Text Function to Copy Only Text from Excel to Word

  • A new window will pop out.
  • Choose “Tab” and then press OK.

Use Convert to Text Function to Copy Only Text from Excel to Word

  • This way we can get our word file ready with only text from the excel file.

Use Convert to Text Function to Copy Only Text from Excel to Word

Read More: How to Insert Excel Table into Word (8 Easy Ways)


Similar Readings


3. Apply Paste Special Tool to Copy Only Text from Excel to Word

Excel has some built-in features to make your work more comfortable. Using a paste special tool you can do this job easily.

Steps:

  • Select the dataset according to your need from an excel worksheet.
  • Press Ctrl+C to copy.

Use Convert to Text Function to Copy Only Text from Excel to Word

  • Now open your word file and select “Paste Special” from the “Paste” option.

  • A new window will open.
  • From the window select “Unformatted Text” then click OK.

  • Here we got our desired output with only text from the excel datasheet.

Read More: Excel VBA: Open Word Document and Paste (3 Suitable Examples)


Things to Remember

  • When copying and pasting from excel to word, the original data format will be changed automatically.

Conclusion

In this article, I have tried to cover all the methods. Hope you find it useful. If you have any queries, please let us know in the comment section. Thanks!


Related Articles

Wasim Akram

Wasim Akram

Hi! my name is Wasim Akram. I am a graduate in mechanical engineering from Ahsanullah University of Science & Technology. I am passionate about learning new things and writing articles. I write article about Microsoft Excel and it's my favourite thing to do.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo