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?
=CONCATENATE("<a href=""http://thevacuumdoctors.com/product/",B27,"/"">Click Here For More Info</a>")
Yes this worked. Woooops, sorry for the wasted post. Maybe someone else will find the solution useful
Bookmarks