Combining columns

[okephoto]

I've been digging through tutorials and help sections trying to come up
with a function that can produce the following:

[image: http://www.gulfislandsguide.com/ex copy.jpg]

where I can take the value of ProductID, insert a dash and put in the
value of ProductWidth so the final result looks like what's in red. I'm
sure there is an easy solution somewhere.

This will solve a problem I have of multiple ProductID numbers when
different sizes are available.

Thanks

 

[Andy Brown]

You could try =A2&"-"&B2 in C2, then drag it down.

HTH,
Andy

 

[Peo Sjoblom]

=A2&"-"&B2

copy down

 

[okephoto]

Thanks, solved the problem and made my day.

Cheers