Removing Hyperlink

[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!

 

[Peo Sjoblom]

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

--


Regards,


Peo Sjoblom

 

[Reitanos]

In the future, you can use Paste Special/Values to capture the text
without any formatting or links.

 

[joaniemic]

Thank you so much... it worked!

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

--


Regards,


Peo Sjoblom