You are trying to assign to B2 some piece of text and the contents of B2...
you can't do that (hence, the circular reference error). B2 either contains
a value or a formula, it can't have both. Either put the formula in another
cell (say, C2) or you will need to use a macro of some sort if you want to
change the value in place.

Rick


"Big UT Fan" wrote in message
...
I tried to use the HYPERLINK function but am getting a circular reference.
In
cell B2 I inserted the following funciton:
=HYPERLINK(CONCATENATE("http://www.foo.com/id=",B2))

What am I doing wrong?


"Ross Culver" wrote:

Just concatenate the constant with the cell value.

Ross


"Big UT Fan" wrote in message
...
I'd like to take the values (numbers) in a particular column to a
hyperlink
in which the number is part of the url. For example, imagine a col of
5
digit #s. In cell A:2 is 12345. I want to change this to a hyperlink
to
the
url http://www.url.com/id=12345. There has to be a way but I've never
done
it. Thanks!