Advanced Excel Concatenation Question

**ReallyCoolGuyYeah** · 05-31-2013, 04:57 PM

How do you simply make every concatenation possible with multiple rows and columns in excel?

excel cc.PNG

This would help a lot. Thanks

**oeldere** · 05-31-2013, 05:04 PM

e1=b1&c1&d1

and drag down

**shg** · 05-31-2013, 05:26 PM

There's a workbook that does this with two methods, one using formulas and one with VBA, at https://www.box.com/s/47b28f19d794b25511be.

**ReallyCoolGuyYeah** · 05-31-2013, 05:36 PM

Thanks a lot shg, thats pretty close to what Im looking for. Ive got to learn VBA

**shg** · 05-31-2013, 06:15 PM

You're welcome.

Re: Advanced Excel Concatenation Question