Yes you can use VBA (that is what I meant by "or you will need to use a
macro of some sort if you want to change the value in place"). The point of
my response dealt with this statement of yours...

In cell B2 I inserted the following funciton:
=HYPERLINK(CONCATENATE("http://www.foo.com/id=",B2))

Placing a formula referring to B2 in the cell B2 is what caused your
circular error. VBA (or a macro if you will) can write directly into a cell
because it is not "in" the cell itself (like a formula on the worksheet is);
rather, it is something that simply has the ability to act on a worksheet in
whole or in part.

Rick


"Big UT Fan" wrote in message
...

So Rick...Are you saying that I still won't be able to do it using VBA as
suggested by Sandusky in the next reply?


"Rick Rothstein (MVP - VB)" wrote:

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!