CODEWITHSUNDEEP
excelhyperlink
L.Dutch
L.Dutch

Reputation: 966

Creating URL with formula in excel

In my excel sheet I am creating URLs by concatenating the content of various cells.

The formula in D2 is =CONCATENATE("http://",A2,".",B2)

enter image description here

The problem I have is that the resulting URL is not seen as a hyperlink, and I have to manually copy, paste as value and then configure the hyperlink to make it work.

Is there a way to let excel recognize it as a URL and make it immediatly clickable?

Upvotes: 3

Views: 5486

Answers (1)

Gary's Student
Gary's Student

Reputation: 96753

In D2 enter:

=HYPERLINK(CONCATENATE("http://",A2,".",B2),CONCATENATE("http://",A2,".",B2))

(you can now replace the second argument with a "user friendly" label)

Upvotes: 4

Related Questions