How do create a hyperlink using a formula?

[MattC475]

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 · Accepted solution]

@MattC475 

Did you try

=HYPERLINK(A1&B1)

[#3]

@MattC475 

Figured this out using YouTube. Used the following formula:

=IF(C55<>"",HYPERLINK(CONCATENATE("https://www.jira.com/",[Jira Id]), "https://www.jira.com"&[Jira Id),"")