Combine Hyperlink with Text

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
 
P

Pete_UK

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
 
Top