+ Reply to Thread
Results 1 to 8 of 8

Thread: Copying Hyperlinks in Excel

  Share/Bookmark
  1. #1

    Reputation Reputation Reputation

    Join Date
    Nov 2007
    Location
    Rotherham
    Posts
    742
    Thank Post
    32
    Thanked 41 Times in 37 Posts
    Rep Power
    16

    Default Copying Hyperlinks in Excel

    I have a spreadsheet with a column of hyperlinks. The text for the cell is sumply the domain, www.edugeek.net for example, however the hyperlink points to the exact site, http://www.edugeek.net/forums/behind-red-door/ for example.

    I would like to show the actual link in a cell. Given that I have over 200 rows this is not something I want to do one at a time is there a quick way to do it?

    To rephrase I have colum's like this: www.edugeek.net

    And I actually just want them like this: http://www.edugeek.net/forums/behind-red-door/

  2. #2

    Reputation Reputation Reputation Reputation Reputation Reputation
    leco's Avatar
    Join Date
    Nov 2006
    Location
    West Yorkshire
    Posts
    1,980
    Blog Entries
    12
    Thank Post
    579
    Thanked 122 Times in 116 Posts
    Rep Power
    32

    Default

    There ought to be a way to copy the address into the Text to display box in the Hyperlink edit dialogue. Maybe a Macro? Don't know of a really quick way.

  3. #3

    Reputation
    Reputation Reputation Reputation Reputation Reputation Reputation Reputation Reputation
    Michael's Avatar
    Join Date
    Dec 2005
    Location
    Birmingham
    Posts
    5,115
    Thank Post
    104
    Thanked 749 Times in 570 Posts
    Rep Power
    150

    Default

    I'm not quite sure what the problem is. I can copy/paste the URL example you gave:

    Code:
    http://www.edugeek.net/forums/behind-red-door/
    
    And it appears in full in Excel 2003. I also tried without http and it just appears as text (not a hyperlink).

  4. #4

    Reputation Reputation Reputation Reputation Reputation Reputation
    leco's Avatar
    Join Date
    Nov 2006
    Location
    West Yorkshire
    Posts
    1,980
    Blog Entries
    12
    Thank Post
    579
    Thanked 122 Times in 116 Posts
    Rep Power
    32

    Default

    As I understood the question - the spreadsheet already contains the short addresses but Stuart_C wants to display the full addresses instead. But of course I could be mistaken.

  5. #5

    Reputation
    Reputation Reputation Reputation Reputation Reputation Reputation Reputation Reputation
    Michael's Avatar
    Join Date
    Dec 2005
    Location
    Birmingham
    Posts
    5,115
    Thank Post
    104
    Thanked 749 Times in 570 Posts
    Rep Power
    150

    Default

    I understand (same as you) but I cannot replicate it

  6. #6

    Reputation Reputation Reputation Reputation Reputation Reputation Reputation

    Join Date
    Dec 2008
    Location
    Queensland
    Posts
    1,103
    Blog Entries
    2
    Thank Post
    17
    Thanked 133 Times in 111 Posts
    Rep Power
    35

    Default

    Quote Originally Posted by Michael View Post
    I understand (same as you) but I cannot replicate it
    You can manually chnage the display of hyperlinks by right clicking > Format/edit Hyperlink > "Text to Display" (thats for 2003 anyway).

  7. #7

    Reputation Reputation Reputation Reputation Reputation Reputation
    leco's Avatar
    Join Date
    Nov 2006
    Location
    West Yorkshire
    Posts
    1,980
    Blog Entries
    12
    Thank Post
    579
    Thanked 122 Times in 116 Posts
    Rep Power
    32

    Default

    Quote Originally Posted by p858snake View Post
    You can manually chnage the display of hyperlinks by right clicking > Format/edit Hyperlink > "Text to Display" (thats for 2003 anyway).
    You can, but if the spreadsheet already contains the short addresses, in a number of columns, how are the cells to be edited? Not one by one as that would take far too long given even a small number of cells.

  8. #8

    Reputation Reputation

    Join Date
    May 2009
    Location
    Sheffield
    Posts
    222
    Thank Post
    14
    Thanked 23 Times in 17 Posts
    Rep Power
    9

    Default

    You can do hyperlinks with a formula (and inspect their properties) - if you're still stuck lemme know

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

     

Similar Threads

  1. Word 2003 Hyperlinks restricted
    By mrbios in forum Windows
    Replies: 8
    Last Post: 18-06-2010, 09:01 AM
  2. Pulling copying fails - push copying works
    By SimpleSi in forum Windows
    Replies: 1
    Last Post: 03-03-2008, 02:29 PM
  3. Cannot cancel copying
    By ranj in forum Mac
    Replies: 5
    Last Post: 11-01-2008, 06:59 PM
  4. Replies: 9
    Last Post: 02-11-2007, 08:55 PM
  5. Hyperlinks built into the desktop background
    By Pottsey in forum Windows
    Replies: 0
    Last Post: 13-10-2006, 02:30 PM

Posting Permissions

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