adding data from multiple columns into one, data seperated by commas

**teko1995** · 03-27-2009, 01:10 AM

Using =A7&","&B7 to add data from two columns into one, separated by a comma.

What about multiple columns, still separated by a comma? Please See Example in attachment

Thank you in advance! Mike

Excel 2007

**Paul** · 03-27-2009, 01:31 AM

Are you not able to simply concatenate more cells in the same way? e.g.

=A4&","&B4&","&C4&","&D4&","&E4&","&A5&","&B5&","&C5&","&D5&","&E5

**teko1995** · 03-27-2009, 07:48 AM

Thank you Paul, this does work well.. I just couldn't get it just right.
Mike

**CindyR** · 02-07-2011, 10:11 PM

I have used the above formula to insert commas between combined cells but not all of my cells have data so I end up with commas hanging in some of the concatenated cells.

how do I adjust the formula so a comma is not added if there is no data in the next cell?

Thanks in advance for your help!