Copying Hyperlinks in Excel

Stuart_C · 19-06-2009, 05:26 PM

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/

leco · 19-06-2009, 10:59 PM

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.

Michael · 19-06-2009, 11:38 PM

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).

leco · 19-06-2009, 11:58 PM

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.

Michael · 20-06-2009, 12:08 AM

I understand (same as you) but I cannot replicate it

p858snake · 20-06-2009, 01:24 AM

Quote:

Originally Posted by Michael

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).

leco · 20-06-2009, 11:25 AM

Quote:

Originally Posted by p858snake

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.

MattMitchell · 08-09-2009, 10:23 PM

You can do hyperlinks with a formula (and inspect their properties) - if you're still stuck lemme know

Welcome, Register for free! or Login below:
User Name		Remember Me?
Password

19-06-2009, 05:26 PM	#1
Stuart_C Join Date: Nov 2007 Location: Rotherham Posts: 449 Thanks: 16 Thanked 28 Times in 24 Posts Rep Power: 10	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/

19-06-2009, 11:38 PM	#3
Michael Join Date: Dec 2005 Location: Birmingham Posts: 4,820 Thanks: 85 Thanked 681 Times in 519 Posts Rep Power: 137	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).

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Pulling copying fails - push copying works	SimpleSi	Windows	1	03-03-2008 03:29 PM
Cannot cancel copying	ranj	Mac	5	11-01-2008 07:59 PM
Word 2003 Hyperlinks restricted	mrbios	Windows	7	21-11-2007 03:27 PM
Stop students browsing the network from word hyperlinks	sidewinder	Windows	9	02-11-2007 09:55 PM
Hyperlinks built into the desktop background	Pottsey	Windows	0	13-10-2006 02:30 PM

Thread Tools	Search Thread
Show Printable Version Email this Page	Search Thread: Advanced Search

		EduGeek.net Forums > Technical > Office Software
Copying Hyperlinks in Excel

19-06-2009, 10:59 PM	#2
leco Join Date: Nov 2006 Location: West Yorkshire Posts: 1,436 Thanks: 469 Thanked 97 Times in 94 Posts Rep Power: 26	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.

19-06-2009, 11:58 PM	#4
leco Join Date: Nov 2006 Location: West Yorkshire Posts: 1,436 Thanks: 469 Thanked 97 Times in 94 Posts Rep Power: 26	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.

20-06-2009, 12:08 AM	#5
Michael Join Date: Dec 2005 Location: Birmingham Posts: 4,820 Thanks: 85 Thanked 681 Times in 519 Posts Rep Power: 137	I understand (same as you) but I cannot replicate it

08-09-2009, 10:23 PM	#8
MattMitchell Join Date: May 2009 Location: Sheffield Posts: 162 Thanks: 11 Thanked 17 Times in 11 Posts Rep Power: 7	You can do hyperlinks with a formula (and inspect their properties) - if you're still stuck lemme know

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Office Software forum sponsored by

Copying Hyperlinks in Excel