Microsoft Word permits us to generate professional standard documents, reports, letters, and any other dataset. But with Excel, we can edit any data quickly and efficiently. So, it will be convenient to use excel instead of using a word document, while working with an editable dataset for any professional work. In this article, we will demonstrate some effective ways to copy from word to excel into multiple cells.
Download Practice Workbook
You can download the workbook and practice with them.
3 Effective Ways to Copy from Word to Excel into Multiple Cells
Copying is mainly the process of replicating text, data, or files resulting in two or perhaps more copies of any file or data portions. This increases the profitability in saving time and tracking many issues. While we need to duplicate a piece of information we use the copy command.
But copying data from one file to another like; Word to Excel may create some problems. And the main problem is we can not copy simple data from word to excel into multiple cells.
To copy from word to excel into multiple cells, we will utilize a word file below to demonstrate our points. There are four columns in the file: Employee ID, First Name, Last Name, and Birth Date. And, in each row, there are some employee details following the column structure.
Now, we will demonstrate three different methods for copying data from word to excel into multiple cells.
1. Use the ‘Paste Special’ Feature to Copy from Word to Excel into Multiple Cells
The Paste Special feature permits the choice of which features of the copied data to paste. In functionalities like Microsoft Office, paste special is a frequent function to use. We can use the Paste Special feature to copy data from word to excel into multiple cells. For this, we need to follow some procedures. Let’s look at the steps to use the paste special feature for copying data from word to excel into multiple cells.
- Firstly, select the whole information of data in Microsoft Word.
- Secondly, go to the Home tab from the ribbon.
- Thirdly, click on Copy, under the Clipboard category.
- Instead of doing this, you can right-click on your selected data and then simply just click on Copy.
- Or, you can use the keyboard shortcut Ctrl + C to copy data.
- Now, go to your excel file and select the cell where you want to copy the data.
- Then, right-click on your mouse and select Paste Special.
- This will appear Paste Special dialog box showing the Source of the copying data.
- Further, choose the Paste option, and from As select the Text type.
- After that, click on the OK button to finish the procedure.
- Finally, you can see that the data is copied into multiple cells as we wish.
- Furthermore, to make the data more organized, we can give it a border. To do this, go to the Home tab from the ribbon in Excel.
- From the Font category, select All Borders from the Borders drop-down menu.
- Lastly, you can see the result is now becoming attractive to see.
2. Utilize ‘Text to Columns’ Data Tool to Duplicate into Several Cells from Word to Excel
The ‘Text to Columns‘ wizard may be used to split the contents of a single Excel cell into multiple columns. It lets us copy data, formatting, formulae, and other items from one cell or column to another by dividing them up using different criteria. We can use this tool to duplicate data from words to excel into multiple cells. Let’s follow the steps down.
- To begin with, open Microsoft Word and select all of the data.
- Next, from the ribbon, select the Home tab.
- Then, under the Clipboard category, select Copy.
- Alternatively, right-click on the data you want to copy and then select Copy.
- You may also copy data using the Ctrl + C keyboard shortcut.
- Further, open the excel file and select the cell where you wish to transfer the data from your excel file.
- Go to the Home tab on your excel file and from the Clipboard category, click on the Paste drop-down menu and select the second option.
- Rather than doing this, you can just right-click on your mouse on the selected cell. Then choose the second option.
- Otherwise, you can just use the keyboard shortcut Ctrl + V.
- This will paste all the copied data if you look at the picture below. This will not be copied in the right order as our preference.
- In the picture below, we can see that the B4 cell contains Employee ID, First Name, Last Name, and Birth Date. But we want them in multiple cells.
- So, we select the pasted data cells and then go to the Data tab from the ribbon.
- From the Data Tools group, click on Text to Columns.
- This will open the Convert Text to Columns Wizard window.
- Now, to complete Step 1 from the wizard, choose Delimited from Choose the file type that best describes your data. A delimiter is a sign or a gap that divides the data to be split.
- Then, click on Next.
- You are in Step 2. As we want to split the data by comma, so, we checkmark the Comma box on the Delimiters checkbox.
- Again, click on Next to go to the next step.
- This is the 3rd or the final step. Here, we have to select the Data Format from Data Preview for each column.
- So, first, select the Employee ID from Data Preview and select General for this data under Column data format.
- We choose Text for First Name and Last Name data.
- Further, we select the Birth Date as the Date and click on Finish to complete the steps.
- After that, you can see all the data is now separated and copied into multiple cells.
- Furthermore, similarly to the previous method, we can also add a border to the data to make it more orderly. To do so, navigate to the Home tab on the Excel ribbon. From the Borders drop-down box, pick All Borders from the Font category.
- Finally, you can observe how the end result has improved in appearance.
3. Apply Copy & Paste Tools for Getting Table from Word to Excel
Copy and Paste allow you to move data from one location to another. The Copy action copies a set of data to the clipboard. The Paste action pastes data from the clipboard into the location where you use it. We can use the Copy and Paste commands to copy a table from word to excel. Let’s look at the steps for this.
- In the first place, open Microsoft Word and select the table which you want to copy from Word and paste into excel.
- Next, pick the Home tab from the ribbon of the word document.
- Then choose Copy from the Clipboard category.
- Otherwise, select Copy by right-clicking on the data you wish to copy.
- The Ctrl + C keyboard shortcut may also be used to copy data.
- Additionally, open the excel file and choose the cell where you want the data from your excel file to be transferred.
- Now, go to your excel file’s Home tab and click on Paste in the Clipboard category.
- Alternatively, you may just right-click on the chosen cell with your mouse.
- After that, select the first option from Paste Options.
- Otherwise, just press Ctrl + V on your keyboard.
- Finally, you can see that the table was copied from word to excel keeping the format.
The above methods will assist you to Copy from Word to Excel into Multiple Cells. Hope this will help you! If you have any questions, suggestions, or feedback please let us know in the comment section. Or you can have a glance at our other articles in the ExcelDemy.com blog!