How to automatically divide the contents of a Word document into multiple columns after copying them into an Excel table?

Sometimes, when we copy and paste the contents of a Word document into an Excel table, the same line of text will be displayed in one column (one cell). In order to display information more intuitively and data processing, we need to Word content automatically divided into Excel tables.merge pdf files i love pdf The following speed office (Speedoffice) as an example, a detailed description of how to achieve this operation.

First of all, the use of Speedoffice to open the Word document, select and copy the contents. Then click on the menu bar in the upper left corner of the "+" button, create a new Excel table.

Next, the copied data will be pasted into the form. At this point, although the content is divided into multiple lines, but only one column. In order to realize the automatic separation, we need to carry out the following steps: select all the text, and then click on the menu bar above the "Data" option, and then select "Text Separation Wizard".

In the pop-up settings window, according to the text content to adjust the "character separator". Usually, if there is no obvious symbols, you can choose "space" as the separator.

After selecting a good separator, you can view the effect of separation through the preview window. If you are satisfied, click "OK" button to complete the operation.

Back to the Excel table, you can see the text has been divided into the corresponding columns. For example, if the identity card number appears to be the case of E + 16, we can modify the cell format to "text" to solve this problem.

Through the above steps, we can easily copy the contents of the Word document into the Excel form is automatically divided into multiple columns, so that the data is more clear and easy to deal with.

Word document Excel table Word

0