Why is that if I try to copy and paste something from a webpage into Excel,
that it will not take it?? Yet, if I copy and paste the same thing to
NotePad, it does take it. Then I have to copy and Paste from NotePad to Excel.
Thank You,
--
George Jurak

Have you asked the experts in one of the Excel newsgroups?

"George Jurak" <(E-Mail Removed)> wrote in message
news:43C58317-5320-46C6-A4DF-(E-Mail Removed)...
: Why is that if I try to copy and paste something from a webpage into
Excel,
: that it will not take it?? Yet, if I copy and paste the same thing to
: NotePad, it does take it. Then I have to copy and Paste from NotePad to
Excel.
: Thank You,
: --
: George Jurak

Try here:
http://www.microsoft.com/communities...&lang=en&cr=US

--
Regards

Ron Badour
MS MVP
Windows Desktop Experience


"George Jurak" <(E-Mail Removed)> wrote in message
news:43C58317-5320-46C6-A4DF-(E-Mail Removed)...
> Why is that if I try to copy and paste something from a webpage into
> Excel,
> that it will not take it?? Yet, if I copy and paste the same thing to
> NotePad, it does take it. Then I have to copy and Paste from NotePad to
> Excel.
> Thank You,
> --
> George Jurak

"George Jurak" <(E-Mail Removed)> wrote in message
news:43C58317-5320-46C6-A4DF-(E-Mail Removed)...
> Why is that if I try to copy and paste something from a webpage into
> Excel,
> that it will not take it?? Yet, if I copy and paste the same thing to
> NotePad, it does take it. Then I have to copy and Paste from NotePad to
> Excel.
> Thank You,
> --
> George Jurak

Hi, George
Copy and paste is used so often and in so many places, we get completely
wrong impressions about what is actually taking place 'under the hood'. We
have no way to peek into the clipboard and see what is actually being put
there by a copy command or what is being extracted by a paste command.
Also, one browser may put a different mix of stuff in the clipboard than
another browser does. Also, the application being pasted to can control
what parts of the clipboard are imported when you do the paste.

Example: You select one cell from a table on an IE web page, and do
Control-C. You then go to Notepad and pasting just delivers the text. You
then go to an HTML editor, and pasting delivers perhaps the HTML for some or
all of the table and row, and almost certainly delivers the complete HTML
for the cell including the formatting info for any text in the cell.

I think your version of Excel is set up to include at least some of the HTML
from the cell. Perhaps there is an option you can set in Excel to only
paste text.

-Paul Randall

George Jurak wrote:
> Why is that if I try to copy and paste something from a webpage into Excel,
> that it will not take it?? Yet, if I copy and paste the same thing to
> NotePad, it does take it. Then I have to copy and Paste from NotePad to Excel.
> Thank You,

Offhand, I think there's an option in Excel when you right-click on a
cell that you can "Paste Special" which includes a Text Only option that
will do what you want.