George Jurak said:
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,
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