Turn text to a hyperlink

Discussion in 'General Software Discussion' started by Calinerti, May 1, 2008.

  1. Calinerti

    Calinerti New Member

    Joined:
    Sep 6, 2002
    Messages:
    330
    Likes Received:
    2
    Trophy Points:
    0
    Hey everyone. I have an little conundrum which is driving me nuts. I want to turn text, such as mywebsite.net , into a hyperlink in M$ Excel. I have to apply it to a column with about 50 or so rows, in each case turning something.something into a clickable link which will open in my browser. I cant for the life of me figure it out. Does anyone out there have a silver bullet fot this?
     
  2. Mousey

    Mousey HH's Official Rodent

    Joined:
    Jan 13, 2007
    Messages:
    7,902
    Likes Received:
    510
    Trophy Points:
    138
    If you highlight the Cell and press Ctrl + K it brings up the Hyperlink dialogue, you can insert a link and the text to display for it :)
     
  3. Calinerti

    Calinerti New Member

    Joined:
    Sep 6, 2002
    Messages:
    330
    Likes Received:
    2
    Trophy Points:
    0
    Thanks for the reply, Mousey! That works, but it also means I have to type in the http:// , THEN what I have already existing. So in A7 for example, I have asite.biz Now if I highlight it and ctrl-k I have to tell it to point to http://asite.biz which is actually more work than just copying and pasting the "asite.biz" directly to the browser. Im working with blocks of 50 or so DAILY. Having to add the http:// to each individually is a curse! I need a way to associate "asite.biz" to http://asite.biz. Is that possible?

    EDIT:
    If its even possible in MS Word I could make that work. Does anyone know if it can be done in Word? Basically I want it to open in a browser without having to add the "http://"
     
    Last edited: May 1, 2008

Share This Page

visited