How can I paste a table of data into Excel from a MSIE / web browser?

Hi

Is there any way to paste out of a table on a web page,
*straight* into msExcel2002, but without taking microsoft all the
friggin Micro$oft formatting with it.

I just want the data, but I also want the table
structure!

Copying out of Firefox into Excel and table structure
is lost - it just splurges out in a single line; and copying out of
MSIE (latest) and either all sorts of formatting comes with it, or the
table structure is lost.

So at present I paste out of MSIE into Excel, save as tab-delimited
text. Close. Re-open. Have to scroll down to find the correct format
out of drop-down list, next, next and then finish.... All do-able but
I'm getting very bored of having to KEEP do so many steps!



Ship
Shiperton Henethe

P.S.
-Does Excel2003 have a better solution?
-Or maybe there's a pluggin I can download from somewhere?

[END]

Try right click in the area of the table and see if
"import to excel" is an option

--
Don Guillett
SalesAid Software
donaldb@281.com
"ship" <shiphen@yahoo.com> wrote in message
news:1116414713.648028.107110@o13g2000cwo.googlegroups.com...
> Hi
>
> Is there any way to paste out of a table on a web page,
> *straight* into msExcel2002, but without taking microsoft all the
> friggin Micro$oft formatting with it.
>
> I just want the data, but I also want the table
> structure!
>
> Copying out of Firefox into Excel and table structure
> is lost - it just splurges out in a single line; and copying out of
> MSIE (latest) and either all sorts of formatting comes with it, or the
> table structure is lost.
>
> So at present I paste out of MSIE into Excel, save as tab-delimited
> text. Close. Re-open. Have to scroll down to find the correct format
> out of drop-down list, next, next and then finish.... All do-able but
> I'm getting very bored of having to KEEP do so many steps!
>
>
>
> Ship
> Shiperton Henethe
>
> P.S.
> -Does Excel2003 have a better solution?
> -Or maybe there's a pluggin I can download from somewhere?
>
> [END]
>

Nope, no such option on my Excel v2002!

Ship
Shiperton Henethe

There is on mine. What is your url?

--
Don Guillett
SalesAid Software
donaldb@281.com
"ship" <shiphen@yahoo.com> wrote in message
news:1116426023.390336.282900@g47g2000cwa.googlegroups.com...
> Nope, no such option on my Excel v2002!
>
> Ship
> Shiperton Henethe
>

On 18 May 2005 04:11:53 -0700, "ship" <shiphen@yahoo.com> wrote:

>Is there any way to paste out of a table on a web page,
>*straight* into msExcel2002, but without taking microsoft all the
>friggin Micro$oft formatting with it.
>
>I just want the data, but I also want the table
>structure!

I've had pretty good luck with paste special and not selecting html.
Comment ... Excel 2000, not 2003.

>Copying out of Firefox into Excel and table structure
>is lost - it just splurges out in a single line; and copying out of
>MSIE (latest) and either all sorts of formatting comes with it, or the
>table structure is lost.

I've not tried Firefox, but with Mozilla, paste special works with
most table data

I asked a related question and got an interesting reply I haven't
tried yet; mine was some data coming in as dates ... suggestion was to
paste into notepad, save as text, import with control ... yes, I did
read your "straight" and understand this isn't the answer you want,
but it may help as a workaround.

George