+ Reply to Thread
Results 1 to 2 of 2

Removing All Hyperlinks

  1. #1
    Forum Contributor
    Join Date
    03-30-2008
    Posts
    121

    Removing All Hyperlinks

    I recently downloaded a list of 3000 stocks symbols, prices and company descriptions from an internet site for offline analysis.

    Unfortunately the list also contains a small thumbnail size chart which
    covers many of the symbols when I load the material into Excel 2002.
    The chart is in picture form not a specific hyperlink. However, if I click
    on an individual chart from the spreadsheet I do connect to the internet
    so there must be a hyperlink underneath.

    I can remove the chart when I click and cut them one by one ---
    however that would be quite time consuming with over 3000 to delete.

    I have tried using a delete hyperlink macro but that didn't do the trick
    either.

    Is there any way to delete all of these hyperlinks in one operation.

    Thanks.

  2. #2
    Forum Contributor
    Join Date
    03-30-2008
    Posts
    121

    Removing Hyperlinks

    I solved my own problem. I first saved the file as a txt file and
    was able to delete the charts from there.

    Thanks.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1