View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Janne Siukkola Janne Siukkola is offline
external usenet poster
 
Posts: 1
Default 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 -