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.

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

NickHK

"Viking" <[email protected]> wrote in message
news:[email protected]...
> 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.
>

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" <[email protected]> wrote in message
> news:[email protected]...
> > 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.
> >