Removing Hyperlink

  • Thread starter Thread starter joaniemic
  • Start date Start date
J

joaniemic

I've cut and pasted names from a website into Excel, but when I click in
the cell it connects to that hyperlink. How can I prevent this and have it be
just normal text? Thanks to anyone who can help me!
 
Copy an empty cell, select the names with the links using the arrow keys, do
edit>paste special and select add

--


Regards,


Peo Sjoblom
 
In the future, you can use Paste Special/Values to capture the text
without any formatting or links.
 
Run this simple macro to delete all web objects:
Sub DeleteWebObjects()
Cells.Hyperlinks.Delete
ActiveSheet.Pictures.Delete
End Sub


Or,,,,,,,,,,,
Data > Import > New Web Query ... navigate to the site you want to import
data from > click the yellow arrow so it turns green (you can select several)
and click 'Import'.

Regards,
Ryan---
 
Thank you so much... it worked!

Peo Sjoblom said:
Copy an empty cell, select the names with the links using the arrow keys, do
edit>paste special and select add

--


Regards,


Peo Sjoblom
Click to expand...
 
Back
Top