Move complex table from Excel to Word

I

inconceivable

I'm attempting to find a clean way of moving 100 pages of a Word table
into Excel.

I found the command to revert the Autonumbering. However, some of the
rows contain a multi-line cell that breaks up into separate rows when
pasted into Excel. I could strip the Paragraph marks down to
Linefeeds, but it will screw up any numbering present and all
formatting.

The easiest thing I found is:
Copy the cell into Notepad (plain text)
Replace Tabs
Change Paragraphs into Linefeeds
paste into Excel.
....for 100 pages.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
Merging from an Excel file with graphics 1
Code to cut a paragraph that's followed by a table 2
Paste to excel from word - auto format problem 1
Move Chart with Text 0
Word Mail Merge - keeping paragraph breaks that appear in original Excel cell data 2
Pasting a cell into bookmarked table from excel vba 1
Help needed! Extracting Heading 3 and Contents from a Word Doc to Excel 0

Top