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 ...
19th June 2009, 06:26 PM #1
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/
19th June 2009, 11:59 PM #2
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.
20th June 2009, 12:38 AM #3
I'm not quite sure what the problem is. I can copy/paste the URL example you gave:
And it appears in full in Excel 2003. I also tried without http and it just appears as text (not a hyperlink).
20th June 2009, 12:58 AM #4
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.
20th June 2009, 01:08 AM #5
I understand (same as you) but I cannot replicate it
20th June 2009, 02:24 AM #6
You can manually chnage the display of hyperlinks by right clicking > Format/edit Hyperlink > "Text to Display" (thats for 2003 anyway).
Originally Posted by Michael
20th June 2009, 12:25 PM #7
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.
Originally Posted by p858snake
8th September 2009, 11:23 PM #8
You can do hyperlinks with a formula (and inspect their properties) - if you're still stuck lemme know
By mrbios in forum Windows
Last Post: 18th June 2010, 10:01 AM
By SimpleSi in forum Windows
Last Post: 3rd March 2008, 03:29 PM
Last Post: 11th January 2008, 07:59 PM
By sidewinder in forum Windows
Last Post: 2nd November 2007, 09:55 PM
By Pottsey in forum Windows
Last Post: 13th October 2006, 03:30 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)