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.
--
Regards,
Tom Ogilvy
"Marc Miller" wrote in message
...
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