Inserting adjecent cell contents

[Aaron]

Hi,

I have a table that I'm inserting into a web page. Each row has a URL which
varies based upon the product ID of it's item. Instead of cutting and
pasting all of the IDs into their appropriate position in the URL, which
will take forever, is it possible to set a point in the of the URL equal to
it's adjacent cell (the product ID)? This would save me so much time. Here
is an example of what I'm looking to do:

Product ID URL
12345 <a
href="www.mysite.com/products/_________>
12346 <a
href="www.mysite.com/products/_________>

and so on where ______ will be filled in by whatever is in the Product ID
column. Please tell me this is possible...I'm developing carpel tunnel
syndrome here.....

Thanks,
Aaron

 

[Dave Peterson]

I'm not sure how your layout looks--it looks kind of funny in the post.

But maybe something like:

="href=""www.mysite.com/products/" & A1 & """>"

did you need another double quote at the end?

 

[Aaron]

Yup, that's what I did. Thanks for the help, it worked great.

Aaron