D
Dan Thorman
i have a rather large (237 pages) word table that I am attempting to put into
Excel in order to manipulate it. If i copy/paste into Excel and chose to
maintain the formatting, i can get the table to come very close to
maintaining the correct format in order to manipulate it. The problem i
encounter is that in one column of the table in Word there are multiple
sections per cell that are separated with blank lines or <RETURN>s Thus,
when i copy/paste into excel, the (for example) 3 sections that should make
up one cell get copied into 3 cells. To fix this problem, i am guessing that
I can simply find/replace these blank lines or endline characters with
spaces, thus turning multiple sections into one. How do I do this?
Thanks in advance for your help! (to further the example, this message is
now split into the two sections that I would like to be able to place in one
cell)
Excel in order to manipulate it. If i copy/paste into Excel and chose to
maintain the formatting, i can get the table to come very close to
maintaining the correct format in order to manipulate it. The problem i
encounter is that in one column of the table in Word there are multiple
sections per cell that are separated with blank lines or <RETURN>s Thus,
when i copy/paste into excel, the (for example) 3 sections that should make
up one cell get copied into 3 cells. To fix this problem, i am guessing that
I can simply find/replace these blank lines or endline characters with
spaces, thus turning multiple sections into one. How do I do this?
Thanks in advance for your help! (to further the example, this message is
now split into the two sections that I would like to be able to place in one
cell)