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

Get FREE Advanced Excel Exercises with Solutions!

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.


How to Copy Only Text from Excel to Word: 3 Effective Methods

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 Export Data from Excel to Word


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 Copy and Paste from Excel to Word Without Cells


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: How to Extract Data from Excel to Word


Things to Remember

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

Download Practice Workbook

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


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

<< Go Back to Export Excel to Word | Export Data from Excel | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Wasim Akram
Wasim Akram

Wasim Akram holds a BSc degree in Industrial and Production Engineering from Ahsanullah University of Science and Technology. Over the past 2 years, he has been actively contributing to the ExcelDemy project, where he has authored more than 150 articles. Now, he is working as an Excel VBA and Content Developer. He likes learning new things about Microsoft Office, especially Excel VBA, Power Query, Data Analysis, and Excel Statistics. He is also very interested in machine learning and... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo