Using a cell value to form part of a hyperlink

[techstoredirect]

I'd like to set up a formula which takes number value in a cell and inserts that value into a hyperlink.

For example, I have a column of order numbers:

A B
1 678678 https://www.onlineshop/my-account/order/678678#
2 678679 https://www.onlineshop/my-account/order/678679#
etc.

I want the formula to reference this number and use it to form part of a hyperlink e.g. https://www.onlineshop/my-account/order/678678# that is displayed in a different cell.

Is this possible and could someone please reply with a sample formula.

Thanks.

 

[Toadstool]

Hi Techstoredirect,

Like this?

Book1
	A	B
1
2	678678	Order 678678
3	678679	Order 678679
4
Sheet1

Cell Formulas
Range	Formula
B2:B3	B2	=HYPERLINK("https://www.onlineshop/my-account/order/"&A2&"#","Order "&A2)

 

[techstoredirect]

Thanks. I'll have a play with that tomorrow and see how I get on.

I'm just trying to input the number from A1 to form part of the URL in B1

A1 = 678678
B1 =

https://www.onlineshop/my-account/order/

678678#