Pull value of a cell and input in another cell that has text in it already?

This is probably VERY simple but I have not been able to figure it out.

I have a table of data for items, and in one column I have links that go to webpages for those items. I need to pull the value from a particular cell and input that within a text link in another cell. For example:

A1 has the value "K111"

in D1 I need to have a link such as "<a href="http://link/K111>Click Me></a>"

You'll notice it's link with the K111 value input in it. I need to replace the K111 code that will put the value there. I know how to do this normally but not when it falls within other text. Is this possible?

Thanks in advance!

I forgot to say what I tried. I tried this, which works, but since I have quotes in my text it won't work.

=CONCATENATE("<a href="http://thevacuumdoctors.com/product/",B2,"/>Click Here For More Infor</a>")

had I just

=CONCATENATE("Text",B2,"Text")

Then it would work..those extra quotes from the Hyperlink are throwing me off.

Uh..I think I figured it out..is this right?

Please Login or Register  to view this content.

Yes this worked. Woooops, sorry for the wasted post. Maybe someone else will find the solution useful