|
|
||||||
|
#1
05-22-06, 01:27 PM
|
|
|
|
|
I have a column containing company names. Each company name has the hyperlink
address to the company website. This is shown in the ScreenTip when the mouse is hovered over the cell and may be individually obtained using 'edit hyperlink...'. I wish to change the cell content to the blue underlined hyperlink address and not the company name. What can I do? |
|
|
|
#2
05-22-06, 01:42 PM
|
|
|
|
|
Hi,
If your cell has the Hyperlink() formula then you can delete the Freindly_Name. =HYPERLINK("www.company.com","CompanyName") to just =HYPERLINK("www.company.com") Regards, Bondi |
|
#3
05-23-06, 04:39 AM
|
|
|
|
|
See [url down]
to extract the hyperlinkaddress with a function from object type hyperlinks (Ctrl+K). There is also one to extract from HYPERLINK Worksheet Function, but they would have to be explicit not derived from formulas. |
|
|
| Similar Threads | |
| multiple Hyperlinks one Excel cell? Is it possible to enter multiple links in one Excel cell? I am using the fuction string rather than the GUI interface. Thanks |
|
| Update 2000 Excel hyperlinks to 2003 hyperlinks I have a spreadsheet with 20,000 hyperlinks to music files. I formed them with 2000 Office, but have now upgraded to 2003 Office and find the old hyperlinks do not work. I... |
|
| How toi turn-off hyperlinks [excel]? Email hyperlinks pop up ! Email hyperlinks pop up as I try to access each cell. I've tried turning off hyperlinks (TOOLS: AUTOCORRECT: AUTOFORMAT AS YOU TYPE. Under REPLACE AS YOU TYPE, I have... |
|
| Can 2 different hyperlinks be in the same Excel cell? I am working in Microsoft Excel 2000. Is there any way possible to place 2 different hyperlinks into the same cell on the same Excel spreadsheet? I am trying to create a... |
|
| Using cell refs in Excel hyperlinks. Is this possible? This would be so useful!! |
|
|
All times are GMT. The time now is 04:19 PM. | Privacy Policy
|
Excel Hyperlinks- cell content v. hyperlinks