Creating URL with formula in excel

Question

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

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

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?

Gary's Student · Accepted Answer · 2017-01-09 12:27:06Z

4

In D2 enter:

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

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

edited Jan 9, 2017 at 12:27

answered Jan 9, 2017 at 12:21

Gary's Student

96.9k10 gold badges66 silver badges104 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Creating URL with formula in excel

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related