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