Hyperlink formula - need to change how it appears

[Dan Morris]

Hi there

I have this very useful formula:

=HYPERLINK("\\server\CVs"&A5&" "&B5)

which creates a hyperlink to a document file on a shared drive according to words in the spreadsheet.

At the moment, this displays the whole hyperlink in the spreadsheet.

Could someone advise what I need to add to the formula so that it just displays as CV

ie: so that it's still the same hyperlink but the whole thing's not displayed?

Thank you. Dan

 

[AliGW]

Like this, Dan:

=HYPERLINK("\\server\CVs"&A5&" "&B5,"CV")

 

[Dan Morris]

Fantastic
Thank you so much Ali.
Wishing you a wonderful Christmas and a very Happy New Year

 

[AliGW]

And the same to you. Glad to have helped!