A questions of versions

[Suze]

Hello all!
I am not a BIG excel user, so I only use an old copy of Excel 2000.
However, one problem has made me consider upgrading. When i copy
information into a block of cells, it is most important that excel does
not copy the formatting! It should keep the formatting of the cells I am
copying into. I know that you can select to copy text only, but for some
reason this just makes a mess if you copy more than one cell. I am
actually copying information from html encoded emails into an excel
worksheek. I can happily copy many cells at once, from an html table
directly into the worksheet, but it wipes out the format of the cells I
am copying in to. AARGH! So the question is, if I buy a more recent copy
of excel does this situation improve?

 

[Guest]

Hi!
I'm not sure further versions of Excel allow you to do what you need.
BUT, if I were you, I would open a new blank workbook, paste in it the text.
Copy it again and paste it with the Edit/Paste Special/Values. The blank
workbook is then closed without saving.
Not perfect... but could work at low cost!

 

[Franz Verga]

Nel post *Suze* ha scritto:

Hello all!
I am not a BIG excel user, so I only use an old copy of Excel 2000.
However, one problem has made me consider upgrading. When i copy
information into a block of cells, it is most important that excel
does not copy the formatting! It should keep the formatting of the
cells I am copying into. I know that you can select to copy text
only, but for some reason this just makes a mess if you copy more
than one cell. I am actually copying information from html encoded
emails into an excel worksheek. I can happily copy many cells at
once, from an html table directly into the worksheet, but it wipes
out the format of the cells I am copying in to. AARGH! So the
question is, if I buy a more recent copy of excel does this situation
improve?

No, I think it should be the same.

To import data in Excel from an HTML source I think the best way is the use
of a Web Query.

Now I don't know how/if Excel 2000 support this funcionality, so I explain
you as it is on Excel 2003.

From menu Data, Import External Data, New Web Query.

in the box Address type your URL and when the pages appear you can select
you want to copy by clicking on the little yellow square with an arrow (it
becomes green with a V) then you will click on Import.

--
(I'm not sure of names of menues, option and commands, because
translating from the Italian version of Excel...)

Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy