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.
- 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 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.
- 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 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.
- 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
- How to Copy from Excel to Word Without Losing Formatting
- How to Link Excel Cell to Word for Automatic Update
- How to Insert an Excel Spreadsheet into Word
- How to Copy a Chart from Excel to Word
- How to Transfer Data from Excel to Word Automatically
<< Go Back to Export Excel to Word | Export Data from Excel | Learn Excel