Re: Copy and paste HTML problem
- From: "Tod" <toddiSAFETYPIN@xxxxxxxxxxx>
- Date: Tue, 3 Oct 2006 18:24:35 +0100
I often copy tables from web to excel but I have not yet found a way to do
it perfectly in one move.
The trouble with Paste Text is you lose the columns and then the
effectiveness of Text-to-Columns depends on what was in the columns.
I usually Paste HTML, remove 'word wrap' and 'merge cells' and then edit and
re-format columns individually. OK, it takes a bit of time, but it's usually
worth it.
Tod
"Excel doubter" <Exceldoubter@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:4AA652BF-E3EA-482A-8173-C0A8723E958E@xxxxxxxxxxxxxxxx
Hi, there. Recently, I need to copy and paste some data (with table) from
the
Internet. However, the data I copied which contains value like 1-0, 2-0
etc
will change to date like Jan-00 and Feb-00 automatically. Well, even I've
tried to format the cell to text only before I paste the data, the problem
still persists. When I try to paste special as Unicode or text only, the
data
appear to be exactly on the web. I need to solve this problem because the
table on the web looks very attractive with assorted colours according to
different groups.
Hope that some experts out there can give a helping hand.
Thank you very much.
.
- Prev by Date: Re: XLS Viewer for 98SE
- Next by Date: Re: Compare Two Rows
- Previous by thread: Combo Box
- Next by thread: Dropdown for whle column
- Index(es):
Relevant Pages
|
