Combine different cell values in to one

[mattmac]

Hi Guys,

I have a list of columns filled with data, say b thru d. What i want to do is combine the cells in the same row (b thru d again) and put that value in column a like this : valueb-valuec-valued

I want to keep going down rows until there is no data left and then I want it to stop. So far I have this (which doesn't work at all, as usual)

Please Login or Register  to view this content.

[sweep]

Hi,

Perhaps this will start you off?

Please Login or Register  to view this content.

[mattmac]

Thanks! that's saved me a major headache!