help with excel

[jamoor]

I have some skills in excel, but only basic ones unfortunatley.

I have a spreadsheet with catalogue numbers in column a

In column B I need to do the following.

www.xyz.com/<CAT NO>

The <CAT NO> needs to be copied from column A on that row, any ideas on how to do that?

Thanks!

 

[jamoor]

ok, actually its a little more complex

http://www.xxx.co.uk/store/index.php?searchStr=<CAT NO HERE>&act=viewCat&Submit=Go

any idea for that?

 

[jamoor]

its not a porn site btw (ha ha)