How to use cell data as part of hyperlink function

T

txlonghorn1989

What I need to do is use the hyperlink function in a column of cells.
Each cell will contain a numeric value which I'd like to have as one of
the parameters in the web address. Formula would need to translate as
....

http://foobar.com/cgi-bin7/xview?family=fiji+type=anything+entity=533451


and 533451 just represents any number I enter into a cell. Is that
clear as mud?

In other words, hyperlink function is associated with every cell (with
a number) in column A. I enter a number or change a number in any
particular cell and it uses the new number as part of the hyperlink.

Thanks for any help you can provide,
Mike
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top