Friday, 29 December 2017

worksheet function - Create a hyperlink from URL and title in Excel

I'm trying to construct a hyperlink from a URL and a name in different cells.


a1 = http://www.example.com/
b1 = example
c1 = example

What I want that is the URL in A1 to is made into a hyperlink with the name taken from B1:


example

I created a formula, but it's not working


&”=b1”

should result in


example

No comments:

Post a Comment

Where does Skype save my contact's avatars in Linux?

I'm using Skype on Linux. Where can I find images cached by skype of my contact's avatars? Answer I wanted to get those Skype avat...