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

S

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.
 
S

Simon Lloyd

Activate the cell that contains the hyperlink, right-click, and the
select -Hyperlink, Remove Hyperlink.- you can only use this when yo
have selected a single cell. To deactivate all hyperlinks, you have t
use a macro.
To create the macro, press -Alt-F11- to activate the Visual Basi
Editor, select -Insert, Module- and then paste this code

Code
-------------------
Sub DelLinks() Cells.Hyperlinks.DeleteEnd Su
-------------------
all hyperlinks on the active sheet become normal text.
sherryp;184588 said:
When I copied text from a website and pasted into excel, everythin
link
back to the website. For example if I click into the cell of the tex
i
excel the webpage from where it originated from comes up. I could no
se
anything in formatting. Please help
Click to expand...

--
Simon Lloy

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com
 
P

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
 
Top