Restricting copied text to one Column
 

I am looking for some help

I have a word doc (150 pages) that I need to copy over to excel and
keep the text in one column using a macro to get it there.

When I try to do this, excel is forcing the text to several colmuns.

Any ideas on how to proceed and keep the text in order?

Thanks for any assistance.

Restricting copied text to one Column
 

Viking,
What results do you get if you PasteSpecial instead ?

NickHK

"Viking" wrote in message
oups.com...
I am looking for some help

I have a word doc (150 pages) that I need to copy over to excel and
keep the text in one column using a macro to get it there.

When I try to do this, excel is forcing the text to several colmuns.

Any ideas on how to proceed and keep the text in order?

Thanks for any assistance.

Restricting copied text to one Column
 

NickHK,
It allows me to paste as text only - with no options to keep it in onw
column.
When I paste it as text it still puts it into several columns.

Thanks
Viking.

NickHK wrote:
Viking,
What results do you get if you PasteSpecial instead ?

NickHK

"Viking" wrote in message
oups.com...
I am looking for some help

I have a word doc (150 pages) that I need to copy over to excel and
keep the text in one column using a macro to get it there.

When I try to do this, excel is forcing the text to several colmuns.

Any ideas on how to proceed and keep the text in order?

Thanks for any assistance.