Word toExcel Macro Help?
Posted by Brett Holcomb on November 02, 2001 9:58 AM
Hello,
This maybe a bit confusing, sorry. I have made a spreadsheet that is trying to show what I would like to do.
I have a bunch (almost 1000) pages in word that I am trying to move over to Excel. If I just cut and paste, Excel puts the information in individual columns when I want the information to be put in rows. The Row headings would be the same for each, just the information under each heading would be different (example- I always have a columnn that says "Structure" but the name of the structue may be different). When I paste over from word, into Excel, it does the following:
Column A Column B
Sturcture: Roof
I would like it to be:
Column A
Structure:
Roof
This isthe beginning,I have a couple of other questions as how to automatically combine text from different cells into one cell but that can wait.
As I said, I have a sampleword document and what I would like to do in Excel if anyone would like to see them. I have had great results on here before, thanks to all of the Excel geniuses who hang out here.
Thanks again,
Brett
Posted by Todd on November 02, 2001 11:31 AM
Just after you paste into excel, paste-special and do transpose.
to combine text, do =a1&b1&" hello "&c2
and so on.
Posted by Brett Holcomb on November 02, 2001 11:41 AM
Todd,
Thatis great...thanks. One other quick question on combining the cells... When I type the formula as you suggested,it puts everything in one long cell. Example, if I have:
1. Look up.
2. Look down.
3. Look around.
Combining them in one cell with the formula will give me:
1. Look up.2. Look down.3. Look around.
Is there anyway that when combined they will remain in a "vertical" appearance as intitally seen, only in one cell instead of a number of them?
Thanks again,
Brett
Posted by Todd on November 02, 2001 12:08 PM
you don't want to put carriage returns inside of cells do you? i don't know if that's possible. I guess I don't understand what the objective of doing that is, though. i think you just have to understand the limitations of excel.
the only other thing i can think of is to combine like i said, but put text wrap on in properties, then change the row height.
