| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Table copied from PDF goes into 1 Column | Excel Discussion (Misc queries) | |||
| Text boxes not gettin selected and copied in a stacked 3-D column | Charts and Charting in Excel | |||
| Text file copied | Excel Discussion (Misc queries) | |||
| Restricting Scroll Prevents Row and Column Choice | Excel Discussion (Misc queries) | |||
| Text Box - Restricting Entry | Excel Programming | |||
Hybrid Mode
