Turn text to a hyperlink

Calinerti · May 1, 2008, 05:50 AM

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

May 1, 2008, 05:50 AM	#1
Calinerti DriverHeaven Addict Join Date: Sep 2002 Location: Elysium Posts: 330 Rep Power: 0	Turn text to a hyperlink 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?

May 1, 2008, 11:00 AM	#2
Mousey Synth's Long Lost Bro Join Date: Jan 2007 Location: Web Design Hell Posts: 7,156 Rep Power: 243 System Specs	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 __________________

May 1, 2008, 11:54 AM	Thread Starter #3
Calinerti DriverHeaven Addict Join Date: Sep 2002 Location: Elysium Posts: 330 Rep Power: 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 by Calinerti; May 1, 2008 at 12:08 PM.