How to remove multiple hyperlinks at once
 

Greetings


I have copied quite large amount of data from my companys web based
information system and pasted it to Excel (XP/2002). In that data were names
that work as hyperlinks to e-mails.

How can I remove multiple (like 100) hyperlinks at once?

I know that if I click one cell containing hyperlink with right mouse button
I got an option of "Remove Hyperlink", but how to do that to two (or one
hundred billion) hyperlinks?

Thank you for any help.

--
- Janne Siukkola -

How to remove multiple hyperlinks at once
 

Once you have pasted the items into Excel (i.e. with the data still
highlighted), press Alt-F11 to take you into the VBE, then CTRL-G to
take you into the Immediate Window, and then type:

selection.hyperlinks.delete (Enter)

This will get rid of all your hyperlinks in one operation.

Hope this helps.

Pete


On Sep 14, 8:22 am, Janne Siukkola
wrote:
Greetings

I have copied quite large amount of data from my companys web based
information system and pasted it to Excel (XP/2002). In that data were names
that work as hyperlinks to e-mails.

How can I remove multiple (like 100) hyperlinks at once?

I know that if I click one cell containing hyperlink with right mouse button
I got an option of "Remove Hyperlink", but how to do that to two (or one
hundred billion) hyperlinks?

Thank you for any help.

--
- Janne Siukkola -