Avatar of phoffric
 asked on

How to Copy Word Table to Excel so that the number of Rows are the same?

Attached below is a Word doc with a sample table that I try to copy to Excel. One row in the Word table may become multiple rows in Excel. That causes other problems when processing the Excel table. Ideally, the copy to Excel gives one row for each ACTION FIELD entry as it does in this Word table.

Word Table showing first 8 rows:
Shows first few lines of Word Table
Excel Table after copying first 8 rows has 22 rows. I would like Excel to have only 8 rows, since that is what Word had.
Shows first few lines of Excel Table - too many rows
Both the full sample Word table, and the attempted copy to Excel (with 22 rows) is attached.
Microsoft OfficeVBAMicrosoft ExcelMicrosoft Word

Avatar of undefined
Last Comment
Martin Liss

8/22/2022 - Mon
Martin Liss

I'm guessing that if you did a global search for the newline character (Chr(13)) and replace it with a space that you could maintain the structure when imported into Excel.

>> global search for the newline character (Chr(13))
In Word, I presume? How to use that (Chr(13)) in a global search?

What I did try is Ctrl/H. Special -> Manual Line Break; and replaced that with a period followed by a space. Almost got there. Although the first row, 2nd Column did shrink a little, it didn't shrink completely. Got:
version date. 
Additional information is shown below

Open in new window

I don't know how to make the two lines become one.
Martin Liss

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question

The solution is to do a global replace for both the manual line break and the paragraph mark. Thank you Martin.
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck

The solution is to do a global replace for both the manual line break and the paragraph mark. Thank you Martin.
When I get to work, I'll record a macro that does these two global replaces. Hope it works at work.

How do you use the chr(13) to do the global replace?
Martin Liss

In the Find & Replace dialog (that you can open with Ctrl+H)
In the "Find what:" box, press and hold the Alt key, and then enter the numbers 013 from the number pad that's on the right side of most keyboards of the keyboard. 013 is the carriage return character. You could also try 010 which is the linefeed character. If either one removes anything, follow it up with the other one.
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.