How to convert a table made in Word into an Excel table

First type:

1, open Excel, positioning the cursor to the cell, click on the menu bar Insert button-objects-in the new, select the object type is a Microsoft Word document.

2, the word form as a whole selected, copied to the Clipboard, open an Excel workbook, on a new worksheet, select the A1 unit, and then paste it.

For example, a price list that has been edited in Word needs to be reported in an Excel form. However, if you have more than one paragraph of text in a cell in a Word table, it can be problematic to convert with the above method. That is, when a word table is pasted into Excel, a cell with more than one paragraph of text appears, with multiple cells, only the cell border between them is "hidden" (gray on the view, not printed).

What's even more troublesome is that the other cells in the row of that cell are the merged cells. A row of the original Word table, in Excel, "occupies" more than one line. Not only ugly, but also bring a lot of inconvenience to editors.

The solution is:

The first step. In Word, "edit" · Replace command to cancel the paragraph in all cells. That is, on the Replace tab of the Find and Replace dialog box, enter a paragraph mark (special character) in the Find what box, and leave blank in the Replace with box, and then click Replace All.

2nd step. Select the Word table as a whole, and then, when you copy it to the Clipboard, open an Excel workbook, select the A1 cell on a new worksheet, and then paste.

3rd step. In the cell where the content needs to be segmented, use the shortcut key-"Alt+enter" section.

Tip: You can't use a merged cell method in Excel to solve the problem. Because, after a cell is merged, you can only keep the contents of the cell that is in the upper-left, and the contents of the other cells are deleted.

The second type:

Step: First select your document in Word (Ctrl + a), click on the "form-convert-Text to form" text-separated position select "paragraph mark"-OK-and then copy the content to Excel.

        note : more attention Span style= "Color:rgb (51, 102, 255);" > Office software tutorials section, triple computer office: 189034526 Welcome to join the