How can I change text copied to excel from webite to not link bac.

[sherryp]

When I copied text from a website and pasted into excel, everything links
back to the website. For example if I click into the cell of the text in
excel the webpage from where it originated from comes up. I could not see
anything in formatting. Please help.

 

[Pete_UK]

Instead of using <paste>, you could use Edit | Paste Special | Values
(check) | OK.

Alternatively, once you have pasted (and the pasted cells are still
highlighted), press Alt-F11 to bring up the VBE, then CTRL-G to enter
the immediate window, and type this:

selection.hyperlinks.delete

then press <enter>.

Hope this helps.

Pete