Combine Hyperlink with Text

  • Thread starter Thread starter Lee Swain
  • Start date Start date
L

Lee Swain

We use hyperlinks on our analysis spreadsheets so that people are able to
trace back to the source data file easily. I like to be able to combine the
hyperlink with some standard text so that the hyperlink makes more sense
(Source: Insureds File: Hyperlink for example) . Does anyway know if this
is possible?

Cheers

Lee
 
The syntax for the HYPERLINK( ) function is:

HYPERLINK(link_location,friendly_name)

This enables you to put a user defined description (friendly_name)
which will appear on the spreadsheet, so you could have something like
"Jump to Insureds File".

Hope this helps.

Pete
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Extract Hyperlink URL as String - Access 2010 0
Hyperlink File Path Changes. Hair loss imminent. 4
Hyperlink to a text file 1
Copy actual URL from hyperlink cell 3
Outlook Outlook 2010 Email Body Messages - Auto Hyperlink 2
Convert Cell Text to Matching Hyperlink????? 5
Hyperlink problem to cell in same workbook 2
Automate creation of a table of hyperlinks? 6

Back
Top