copy word table to excel keep formatting

For more information visit you accumulate lots of data in Word tables, or you use lots of Word tables to list data records, you may at some point want to export all this data into Excel. Vera Chen is a data recovery expert in DataNumen, Inc., which is the world leader in data recovery technologies, including recover xlsx and pdf repair software products. Therefore, it becomes more important than ever to get a qualified repairing tool to fix your broken document. Have you ever fall the victim to Word corruption? If so, you will understand how desperate one might get. The effect is as same as that in method 1.

Open Excel and press “Ctrl+ V” to paste the texts there.

Next there will be a message box indicating what you need to do next.

MsgBox ('Now you can just open a Excel worksheet to paste the text')

Selection.Style = ActiveDocument.Styles('Normal') Sub CopySelectParagraphWordByWordToExcel()

Double click the module to open it and paste the following codes:.

And choose “Module” to create a new one.

Then click “Normal” and “Insert” in order.

Next press “Alt+ F11” to open VBA editor.

Similarly, make a copy first and select all target texts.Method 2: Use VBA Codes to Reduce Workload Open Excel and press “Ctrl+ V” to paste the list.Now press “Ctrl+ C” to copy the word list.This time enter “^p^p” in “Find what” text box and “^p” in “Replace with” box.So to remove it, you need to invoke the “Find and Replace” box again. But there is also a blank line as follows: Now you can see each word is in one line.Next place cursor at “Replace with” text box and enter “^p” there.Put cursor at the “Find what” text box and enter a space there.Thirdly, press “Ctrl+ H” to trigger the “Find and Replace” box.To do this, press “Alt+ Ctrl+ Shift+ S” to open the “Styles” window. Secondly, select all target texts and apply them with “Normal” style.This is extremely important and we will conduct all operations in the copy file to prevent from data loss. To begin with, make a copy of the target document.Method 1: Make Use of the “Find and Replace” Option The 2 methods bellow will enable you to paste texts from a document to excel sheet and list each word in a column cell.

Then our topic today shall be a great help. If you are a linguist, you probably need to do the word frequency count a lot. In this post, we are thrilled to share with you 2 ways to copy texts from Word to Excel with each word in a separate cell.

Copy word table to excel keep formatting