importing tables into excel file?

Question

I have a bunch of tables in a word document, and want to copy them as is into excel. Everything works fine, except one of the table contains text over several lines. Excel then makes each line a new cell. Any ideas?

Thanks

Answer 1

Before you copy over, use word search and replace tool to replace manual line breaks with some letters combination eg --
This way the text in the box is now a one line item. eg my--story--being--done
instead of
my
story
being
done

Now you can copy and paste over to excel. Use alt+enter key to break the words apart again

Answer 2

First reproduction the information into Excel. Then decide on all of the information. Then click on archives -> text fabric to columns. % fastened width. there are alternatives to rename each column and you will possibly be able to trim the information making use of the Trim function.