Turn text to a hyperlink

Calinerti · Apr 30, 2008, 10:50 PM

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?

Mousey · May 1, 2008, 04:00 AM

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

Calinerti · May 1, 2008, 04:54 AM

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://"