• 544K Members
• 6,543 Online
• 649K Conversations
SOLVED

## How do create a hyperlink using a formula?

Occasional Contributor

# How do create a hyperlink using a formula?

Cell A = www.jira.com/

Cell B = P1-123

Cell C = Cell A & Cell B = www.jira.com/P1-123 = great!

However, then, I copy the formula down and this happens:

Cell A = www.jira.com/

Cell B = P1-124

Cell C = Cell A & Cell B = www.jira.com/P1-124 = BUT - when I click edit hyperlink it shows P1-123 - is there a way to adjust the formula or equivalent so that is shows a link to www.jira.com/P1-124 instead of www.jira.com/P1-123??

In short, it displays at www.jira.com/P1-124 but when clicked goes to www.jira.com/P1-123.

Is there a way to solve this without VBA?

My current formula is:

=IF(C7<>"","https://www.jira.com/"&C7,"")

2 Replies
Highlighted
Solution

# Re: How do create a hyperlink using a formula?

Did you try

``=HYPERLINK(A1&B1)``
Highlighted

# Re: How do create a hyperlink using a formula?

Figured this out using YouTube. Used the following formula: