URL Hyperlinking: URL has two values in which to input data

[jeffcoleky]

I wish to use a formula to grab data out of cells A1 & B1 and use that data to complete a hyperlink URL in cell A3. The base URL never changes but the last two variables do. For instance:

URL Format:
http://www.test.com/XXXX&page=XXX

Example data:
Cell A1 = 1234 (always 4 digits)
Cell A2 = 567 (always 3 digits)

Desired Final Result, hyperlink:
http://www.test.com/1234&page=567

I cannot seem to figure it out.... my formula i have gives errors: =HYPERLINK("http://www.test.com/"(A1)"&page="(A2), "Linked")

Please help!

PS. this is Excel 2010

 

[Norie]

Try this.

=HYPERLINK("http://www.test.com/"&A1&"&page="&A2, "Linked")

 

[jeffcoleky]

Try this.

=HYPERLINK("http://www.test.com/"&A1&"&page="&A2, "Linked")

Worked Perfectly! THanks!