Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 8
Default 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.

  #2   Report Post  
Posted to microsoft.public.excel.programming
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.



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 8
Default 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.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Table copied from PDF goes into 1 Column Webcentre Excel Discussion (Misc queries) 1 August 13th 08 06:31 PM
Text boxes not gettin selected and copied in a stacked 3-D column Fenil Shah[_2_] Charts and Charting in Excel 1 January 4th 08 12:22 PM
Text file copied Pammy Excel Discussion (Misc queries) 2 October 4th 07 01:57 PM
Restricting Scroll Prevents Row and Column Choice Colin Hayes Excel Discussion (Misc queries) 3 June 11th 07 12:36 AM
Text Box - Restricting Entry Paul W Smith[_3_] Excel Programming 2 July 31st 04 12:25 AM


All times are GMT +1. The time now is 11:55 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"