Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hyperlinks in Excel
I am using Excel to run a query against a SQL database.
One of the colums that is being returned is a web site address (e.g., http://www.mywebsite.com) Is there any way to format the column so that the data being returned becomes a live hyperlink rather than just a text string of the web site address? Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hyperlinks in Excel
Hi Art,
What version of Excel, you have to have at least Excel 2002 to be able to turn off hyperlinks, and at least Excel 97 to have hyperlinks. See if the hand for a hyperlink appears you may have just formatted it with a style so that the underlined blue indication is not present. Does F2 then Enter create the hyperlink. That is just reentering it. If that woks you could probably use the TrimALL macro, which you might try even if F2 then Enter doesn't work. http://www.mvps.org/dmcritchie/excel/join.htm#trimall If you have hyperlinks turned off then try Creating Hyperlinks for all Cells in a Selection (#MakeHyperlinks) http://www.mvps.org/dmcritchie/excel...MakeHyperlinks or MakeHyperlinkFormulas from URL address or Email addresses http://www.mvps.org/dmcritchie/excel...erlinkFormulas If there is something else happening, I don't use SQL, if you want to leave that cell untouched you could use =HYPERLINK(a1,"[x]") and click on the [x] in the cell. The purpose of the string '[x]" is just to have something short and distinctive rather than also repeating what you already have visible. HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Art" wrote l... I am using Excel to run a query against a SQL database. One of the colums that is being returned is a web site address (e.g., http://www.mywebsite.com) Is there any way to format the column so that the data being returned becomes a live hyperlink rather than just a text string of the web site address? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hyperlinks: Hyperlinks change on copy/paste? | Excel Worksheet Functions | |||
Update 2000 Excel hyperlinks to 2003 hyperlinks | Excel Worksheet Functions | |||
How toi turn-off hyperlinks [excel]? Email hyperlinks pop up ! | Excel Discussion (Misc queries) | |||
Excel Hyperlinks- cell content v. hyperlinks | Excel Discussion (Misc queries) | |||
hyperlinks in excel | New Users to Excel |