Need to get from Excel to Word ...somehow!

[Hugh Stanley]

I put out a weekly newsletter that compiles information from varioius
websites, a portion of this is developed from Excel. ...I start
sorting as many as 30,000 articles and winnow it down to 85. I wind
up with one column that I need to transfer to HTML and have it where I
can edit it.

This was no problem up until this weekend when after a hard drive
crashed I upgraded from Office 97 to XP Office, and I had to upgrade
from Mozilla to SeaMonkey for HTML editing.

Within the Excel Sort column I would begin with:

News Story Title (with hyperlink)
Synopsis of news story

News Story Title (with hyperlink)
Synopsis of news story

and so on,

With the old versions of Excel and the HTML editor I was able to get
it to one line for each pair that read like:

News Story Title (with hyperlink) Synopsis of news story

With the new Office software and HTML editing stuff, the transfer
from Excel to HTML leaves every hyper link in its own grid and every
synopsis in its own grid. I can't get rid of these stinkin grids! -
as best I can tell.

I'm interested in removing the grids and getting everything back in an
editable format, or just making a smooth translation from Excel to
HTML ...does anyone have a clue on how to do this? I've been
scratching my head on this for 4 days now.

[FYI: this was also posted to the discussion group "Mr. Excel" ...to
no avail]

Thanks,

- Hugh -

 

[Mark Ivey]

There are several editing techniques, but if you just want to transfer a
range to MS Word...

Take a look here: http://peltiertech.com/Excel/XL_PPT.html#rangewd

 

[Hugh Stanley]

As I understand from reading this, they are transferring Excel to PPT
for a presentation and aren't interested in retaining hyperlinks. I
am.

....I can get the information across where it LOOKS like the original,
or I can get a huge mass of unedited text across with the hyperlinks
imbedded ...but I can't get it in an editable format, with the
hpertexts, and having the same look as the original...

There are several editing techniques, but if you just want to transfer a
range to MS Word...

Take a look here: http://peltiertech.com/Excel/XL_PPT.html#rangewd

I put out a weekly newsletter that compiles information from varioius
websites, a portion of this is developed from Excel. ...I start
sorting as many as 30,000 articles and winnow it down to 85. I wind
up with one column that I need to transfer to HTML and have it where I
can edit it.

This was no problem up until this weekend when after a hard drive
crashed I upgraded from Office 97 to XP Office, and I had to upgrade
from Mozilla to SeaMonkey for HTML editing.

Within the Excel Sort column I would begin with:

News Story Title (with hyperlink)
Synopsis of news story

News Story Title (with hyperlink)
Synopsis of news story

and so on,

With the old versions of Excel and the HTML editor I was able to get
it to one line for each pair that read like:

News Story Title (with hyperlink) Synopsis of news story

With the new Office software and HTML editing stuff, the transfer
from Excel to HTML leaves every hyper link in its own grid and every
synopsis in its own grid. I can't get rid of these stinkin grids! -
as best I can tell.

I'm interested in removing the grids and getting everything back in an
editable format, or just making a smooth translation from Excel to
HTML ...does anyone have a clue on how to do this? I've been
scratching my head on this for 4 days now.

[FYI: this was also posted to the discussion group "Mr. Excel" ...to
no avail]

Thanks,

- Hugh -

 

[Ed]

When you have your finished product in Excel, just before you begin your
transfer, what does it look like? Everything on one line (in one cell?)

Where does Word fit into this?

Ed