#### mark-davis

##### New Member

- Joined
- Dec 10, 2009

- Messages
- 13

What a wonderful forum and I am sure this problem will get answered. Ideally, I'd like it solved with equations instead of VB.

I have 3 columns (column A, B, and C), each with 3 rows of data in Excel. I would like to concatenate each cell in A with each cell in columns B and C in the following manner:

cell d1--> concatenate(a1," ",b1," ",c1)

cell d2, concatenate a1+b1+c2

cell d3 concatenate a1+b1+c3

cell d4 concatenate a1+b2+c1

cell d5 concatenate a1+b2+c2...repeat according this sequence

Eventually, the last cell in column d will be concatenate a3+b3+c3.