Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Word to Excel
Hi...Following on from earlier dud post.
I have a word document in which is a list 200 lines vertically long. On each line is a heading. I need to get these headings to populate line 1 of a spreadsheet 200 columns wide. Any clever boffins out there who can do this? Desperate!!! Gordon... |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Word to Excel
Gordon,
It's 200 now ? As Harold explained, in Excel it would make a bit difference if you talking about more or less than 256 columns. How are your "columns" in Word defined ? NickHK "Gordon" wrote in message ... Hi...Following on from earlier dud post. I have a word document in which is a list 200 lines vertically long. On each line is a heading. I need to get these headings to populate line 1 of a spreadsheet 200 columns wide. Any clever boffins out there who can do this? Desperate!!! Gordon... |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Word to Excel
Hi Nick...
No, still original number but I didn't want to put people off and get over the first hurdle. Nothing defines the word list other than that the list begins on line 1 and ends on line 200...so something that says... Line one in Word to cell A1 in Excel, line Two in Word to cell B1 in Excel Thanks...any help would be fab... Gordon "NickHK" wrote: Gordon, It's 200 now ? As Harold explained, in Excel it would make a bit difference if you talking about more or less than 256 columns. How are your "columns" in Word defined ? NickHK "Gordon" wrote in message ... Hi...Following on from earlier dud post. I have a word document in which is a list 200 lines vertically long. On each line is a heading. I need to get these headings to populate line 1 of a spreadsheet 200 columns wide. Any clever boffins out there who can do this? Desperate!!! Gordon... |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Word to Excel
Hi Gordon,
Copy theWord headings Paste the copied data to (say) A2 of the required worksheet Edit Copy Select the first cell of the header row, e,g, A1 Edit PasteSpecial | Transpose Delete the data in A2:A201 --- Regards, Norman "Gordon" wrote in message ... Hi...Following on from earlier dud post. I have a word document in which is a list 200 lines vertically long. On each line is a heading. I need to get these headings to populate line 1 of a spreadsheet 200 columns wide. Any clever boffins out there who can do this? Desperate!!! Gordon... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need Excel count of 1 word if found in multi-word cells of column | Excel Worksheet Functions | |||
Excel 7, paste linked to word becomes black when word pdf'd | Excel Discussion (Misc queries) | |||
Copy from Word to Excel, and retain indent, plus word wrap | Excel Discussion (Misc queries) | |||
Import cells from excel into word and create multiple word docs | Excel Programming | |||
Printing Word Document using Excel Programming hangs Word | Excel Programming |