Concatenate partial URL with cell value

[cfcMalky]

Hi folks

I am making a table in excel where I list video games and I would like to place a hyperlink in line with them to open a search page on eBay, I've made a URL-friendly cell (replacing the spaces with + signs, like they do on the URL.

Example table:

game title

game+title

Check

<tbody>
</tbody>

On the "Check" cell I would like a hyperlink that contains the value of the cell saying "game+title" (supposing that is cell B2), i.e:

http://www.ebay.co.uk/sch/i.html?_from=R40&_nkw=B2&_in_kw=1&_ex_kw=&_sacat=1249&LH_Sold=1&_udlo=&_udhi=&LH_BIN=1&LH_ItemCondition=3&_samilow=&_samihi=&_sadis=200&_fpos=&LH_SubLocation=1&_fsradio2=%26LH_PrefLoc%3D1&_sargn=-1%26saslc%3D1&_salic=3&_saact=3&LH_SALE_CURRENCY=0&_sop=13&_dmd=1&_ipg=50&LH_Complete=1

How would I go about it?

Thanks in advance folks!

 

[mole999]

I would expect to see these wrapped in quotes

so

="http://www.ebay.co.uk/sch/i.html?_from=R40&_nkw=" & B2 & "&_in_kw=1&_ex_kw=&_sacat=1249&LH_Sold=1&_udlo=&_udhi=&LH_BIN=1&LH_ItemCondition=3&_samilow=&_samihi=&_sadis=200&_fpos=&LH_SubLocation=1&_fsradio2=%26LH_PrefLoc%3D1&_sargn=-1%26saslc%3D1&_salic=3&_saact=3&LH_SALE_CURRENCY=0&_sop=13&_dmd=1&_ipg=50&LH_Complete=1"

 

[cfcMalky]

I would expect to see these wrapped in quotes

so

="http://www.ebay.co.uk/sch/i.html?_from=R40&_nkw=" & B2 & "&_in_kw=1&_ex_kw=&_sacat=1249&LH_Sold=1&_udlo=&_udhi=&LH_BIN=1&LH_ItemCondition=3&_samilow=&_samihi=&_sadis=200&_fpos=&LH_SubLocation=1&_fsradio2=%26LH_PrefLoc%3D1&_sargn=-1%26saslc%3D1&_salic=3&_saact=3&LH_SALE_CURRENCY=0&_sop=13&_dmd=1&_ipg=50&LH_Complete=1"

Sorry, I should've already mentioned, I've tried doing it that way and i get the message saying that the formula is limited to 255 characters, so I've to try using Concatenate or the Concatenate operator (&), It's when I try to use Concatenate, it all goes Pete Tong