Re: Copy/Paste w/o all the styles from web & links...

From: Frank Kabel (frank.kabel_at_freenet.de)
Date: 03/12/04 

Date: Sat, 13 Mar 2004 00:08:01 +0100

Hi
have you tried 'Paste Special' ('Edit - Paste Special'):
- either directly after copying from your web page
- or after you have copied the data select the data, copy it and insert
it again on a blank *** as Values. You may record a macro while doing
this 

--
Regards
Frank Kabel
Frankfurt, Germany
orbii wrote:
> hi, i do a lot of work w/ the web on data, and everytime i copy from
> web and paste into excel, it transfer all the styles over.  is there
> a way to switch it off?  that includes the links too, can that be
> turned off too?
>
> i'm having it up to my neck trying to figure out how i can do this in
> a lot more simpler way.  i dont' want to have to every time...
>
>   copy from web >
>   paste excel sheet1 >
>   recopy entire sheet1 >
>   paste notepad >
>   recopy entire notepad >
>   paste excel sheet2 >
>   formatting... etc etc
>
> just a note on the side, copying from the web to notepad i loose my
> tab delaminated value, so can you imagine the amount of time this
> takes? thankyou so much for he/she who can help me with this dilemma
> :(
>
> orb