+ Reply to Thread
Results 1 to 7 of 7

remove hyperlink in bulk

  1. #1
    Registered User
    Join Date
    11-01-2006
    Posts
    45

    remove hyperlink in bulk

    Hi,

    I am copy data from a website and pasting onto excel, what i need to do is to remove the hyperlinks as i can't click on a cell to edit without it launching the web page. when i do it individually and go into the formatting menu the 'remove hyperlink' option is there, however, when i highlight all the cells it only give me option to edit the hyperlink which would mean i can change them all i assume, but it still leaves me with the prob of having to remove the hyperlink for all cells.

    Is there any way to do this? I have hundreds of these to do each month so it would be really useful if i could remove the hyperlink in bulk.

    [Edit] or even if there is an option to just block all hyperlinks within a worksheet as i have no need for these.

    thanks,
    CC

  2. #2
    Forum Contributor
    Join Date
    03-14-2006
    Location
    Pakistan
    Posts
    1,791

    Lightbulb

    Quote Originally Posted by CC_mfc
    Hi,

    I am copy data from a website and pasting onto excel, what i need to do is to remove the hyperlinks as i can't click on a cell to edit without it launching the web page. when i do it individually and go into the formatting menu the 'remove hyperlink' option is there, however, when i highlight all the cells it only give me option to edit the hyperlink which would mean i can change them all i assume, but it still leaves me with the prob of having to remove the hyperlink for all cells.

    Is there any way to do this? I have hundreds of these to do each month so it would be really useful if i could remove the hyperlink in bulk.

    [Edit] or even if there is an option to just block all hyperlinks within a worksheet as i have no need for these.

    thanks,
    CC
    check this link

    http://http://www.excelforum.com/sho...d.php?t=556472

  3. #3
    Registered User
    Join Date
    11-01-2006
    Posts
    45
    Quote Originally Posted by starguy

    thanks for quick reply but the link's not working.

  4. #4
    Forum Contributor
    Join Date
    03-14-2006
    Location
    Pakistan
    Posts
    1,791

    Lightbulb

    Quote Originally Posted by CC_mfc
    thanks for quick reply but the link's not working.
    here is the method

    You can select the range of cells that contain hyperlinks.

    Then hit alt-f11 to get to the VBE
    then hit ctrl-g to see the immediate window
    type this and hit enter:
    selection.hyperlinks.delete

    You can select as many or as few cells as you want.

  5. #5
    Registered User
    Join Date
    11-01-2006
    Posts
    45
    Thanks alot, clearly there is alot more to excel than I am aware of, that worked great. Need to see what else i can do now...


  6. #6
    Forum Contributor
    Join Date
    03-14-2006
    Location
    Pakistan
    Posts
    1,791

    Lightbulb

    Quote Originally Posted by CC_mfc
    Thanks alot, clearly there is alot more to excel than I am aware of, that worked great. Need to see what else i can do now...

    my pleasure that it helped you.
    thanks for the feedback.

  7. #7
    Registered User
    Join Date
    03-22-2012
    Location
    Chicago
    MS-Off Ver
    Excel 2007
    Posts
    1

    Re: remove hyperlink in bulk

    I second the thanks, as I'm cleaning investor contact info. for a client of mine.

+ 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