thanks, that makes sense, but I still have a problem while I'm trying
to put this in A1,
=hyperlink("http://example.com?id=&a1, a1), I got an error saying excel
can't calculate a formula.
can you help?

Dave Peterson 写道：

You don't even need that other column of numbers.

Put this in A1:
=hyperlink("http://example.com?id="&row())





Ken wrote:

Greetings,

there is a column is number, I want to add a hyperlink to the each
number.
for example,

item A, row 1 is number 1, after the adding the hyperlink to it which
displays 1 but I can click it and link to http://example.com?id=1.
and for row 2, the link will be http://example.com?id=2, and so on.

how to do this?

--

Dave Peterson