LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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 -
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to remove multiple hyperlinks from a document Azra Excel Discussion (Misc queries) 3 December 28th 06 12:18 PM
Remove Hyperlinks from multiple cells at the same time Remove Hyperlinks from multiple cells Excel Discussion (Misc queries) 1 March 20th 06 03:29 AM
Remove multiple hyperlinks in an Excel spreadsheet Leon Excel Discussion (Misc queries) 3 March 17th 06 05:24 PM
How do I remove multiple hyperlinks in the same cell (Excel)? Hyper Charts and Charting in Excel 0 January 16th 06 06:24 PM
remove hyperlinks Dave Excel Discussion (Misc queries) 2 March 4th 05 12:40 AM


All times are GMT +1. The time now is 07:23 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"