Create a hyperlink with querystring from cell

[Marc Miller]

Hi all....

I have an Excel column that contains project numbers, and I have
Web reporting that reports on those projects. What I would like
to do is have a column in the Excel spreadsheet that concatenates
the URL to my web with the value of the project number column, i.e.

A B

Proj. # Report
1 12-1215 http://www.myreports.com?param=(value of cell A1)
2 12-1216 http://www.myreports.com?param=(value of cell A2)

I can't seem to fall on the syntax.

Any and ALL help is appreciated.

Marc

 

[Tom Ogilvy]

Look at the worksheet function
=Hyperlink("http://www.myreports.com?param=(" & A1, & ")")


if the parens aren't required, don't use them. It was your example.

 

[Marc Miller]

Tom,

Thank you, thank you, thank you! It works seamlessly!

Marc