Thanks for the timely reply Barb. The formula works, but now the acct number
shown in that cell shows up as a hyperlinked 0. Anyway to have it still show
the account number?

Bob


"Barb Reinhardt" wrote in message
...
Try something like this

=HYPERLINK("http://www.JJJ.com/KKK/LLL/acct.asp?id="&J1)

=hyperlink("http"Bob Smith" wrote in
message ink.net...
I have a number of different regional account workbooks. In each, a
worksheet with company names, addresses, etc, and account numbers.Account
numbers are in column J.

I would like to access each company on the company server without
creating individual hyperlinks for each company. Anyway to create and
copy a hyperlink to refer to the account number in the J column cells.
The hyperlink is http://www.JJJ.com/KKK/LLL/acct.asp?id= (I've spoofed
the url) where the account number would be the number listed in cell and
follow the = sign.

Any easy way to do this?

Thanks for any advice.

Regards, Bob