View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
NickHK NickHK is offline
external usenet poster
 
Posts: 4,391
Default 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.