Word to Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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...
 
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
 
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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Word to Excel 3
Excel VB to capture the current cells row number 4
Excel spreadsheet to Word document 1
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Working on segments of data from within a list 1
Excel chart, set a vertical baseline on a certain date 0
Word table to excel 1

Back
Top