+ Post New Thread
Results 1 to 8 of 8
Office Software Thread, Copying Hyperlinks in Excel in Technical; I have a spreadsheet with a column of hyperlinks. The text for the cell is sumply the domain, www.edugeek.net for ...
  1. #1

    Join Date
    Nov 2007
    Location
    Rotherham
    Posts
    1,679
    Thank Post
    122
    Thanked 126 Times in 102 Posts
    Rep Power
    46

    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
    leco's Avatar
    Join Date
    Nov 2006
    Location
    West Yorkshire
    Posts
    2,026
    Thank Post
    595
    Thanked 125 Times in 119 Posts
    Rep Power
    42
    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

    Michael's Avatar
    Join Date
    Dec 2005
    Location
    Birmingham
    Posts
    9,345
    Thank Post
    242
    Thanked 1,602 Times in 1,278 Posts
    Rep Power
    346
    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
    leco's Avatar
    Join Date
    Nov 2006
    Location
    West Yorkshire
    Posts
    2,026
    Thank Post
    595
    Thanked 125 Times in 119 Posts
    Rep Power
    42
    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

    Michael's Avatar
    Join Date
    Dec 2005
    Location
    Birmingham
    Posts
    9,345
    Thank Post
    242
    Thanked 1,602 Times in 1,278 Posts
    Rep Power
    346
    I understand (same as you) but I cannot replicate it

  6. #6
    p858snake's Avatar
    Join Date
    Dec 2008
    Location
    Queensland
    Posts
    1,491
    Thank Post
    37
    Thanked 175 Times in 151 Posts
    Blog Entries
    2
    Rep Power
    52
    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
    leco's Avatar
    Join Date
    Nov 2006
    Location
    West Yorkshire
    Posts
    2,026
    Thank Post
    595
    Thanked 125 Times in 119 Posts
    Rep Power
    42
    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

    Join Date
    May 2009
    Location
    Sheffield
    Posts
    275
    Thank Post
    27
    Thanked 40 Times in 30 Posts
    Rep Power
    22
    You can do hyperlinks with a formula (and inspect their properties) - if you're still stuck lemme know



SHARE:
+ Post New Thread

Similar Threads

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

Thread Information

Users Browsing this Thread

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

Posting Permissions

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