+ 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,675
    Thank Post
    122
    Thanked 126 Times in 102 Posts
    Rep Power
    45

    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
    41
    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,262
    Thank Post
    242
    Thanked 1,568 Times in 1,250 Posts
    Rep Power
    340
    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
    41
    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,262
    Thank Post
    242
    Thanked 1,568 Times in 1,250 Posts
    Rep Power
    340
    I understand (same as you) but I cannot replicate it

  6. #6
    p858snake's Avatar
    Join Date
    Dec 2008
    Location
    Queensland
    Posts
    1,490
    Thank Post
    37
    Thanked 175 Times in 151 Posts
    Blog Entries
    2
    Rep Power
    51
    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
    41
    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
    243
    Thank Post
    23
    Thanked 35 Times in 26 Posts
    Rep Power
    20
    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, 09:01 AM
  2. Pulling copying fails - push copying works
    By SimpleSi in forum Windows
    Replies: 1
    Last Post: 3rd March 2008, 02:29 PM
  3. Cannot cancel copying
    By ranj in forum Mac
    Replies: 5
    Last Post: 11th January 2008, 06:59 PM
  4. Replies: 9
    Last Post: 2nd November 2007, 08:55 PM
  5. Hyperlinks built into the desktop background
    By Pottsey in forum Windows
    Replies: 0
    Last Post: 13th October 2006, 02: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
  •