help with excel

jamoor · 12 Dec 2007 at 16:29

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!

div0 · 12 Dec 2007 at 16:32

In B1...

=CONCATENATE("www.xyz.com/",A1)

Drag formula down for all in column B

allllec · 12 Dec 2007 at 16:34

A1 = <cat no>
B1 = www.xyz.com
C1 = =B1&A1

then use select cell C1 and use the little handle thing to drag it down to bottom

then edit as you see fit.

lame way to do it but works

*damn*

beaten with a cleverererer way

marc2003 · 12 Dec 2007 at 16:35

="www.xyz.com/" & a1

edit: bah. too slow.

jamoor · 12 Dec 2007 at 16:41

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?

allllec · 12 Dec 2007 at 16:43

=CONCATENATE(" http://www.xxx.co.uk/store/index.php?searchStr=",A1,"&act=viewCat&Submit=Go")

should work fine.

jamoor · 12 Dec 2007 at 16:47

its not a porn site btw (ha ha)

allllec · 12 Dec 2007 at 17:00

Sure sure