Wasim Akram
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.
- 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”.
- 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.
- A new window will pop out.
- Choose “Tab” and then press OK.
- This way we can get our word file ready with only text from the excel file.
Read More: How to Insert Excel Table into Word (8 Easy Ways)
Similar Readings
- Copy from Excel to Word Without Losing Formatting (4 Easy Ways)
- How to Convert Excel to Word Labels (With Easy Steps)
- Open Word Document and Save As PDF or Docx with VBA Excel
- How to Generate a Word Document from an Excel Macro
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.
- 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!
