Mconcat combining multiple cells with line breaks

**Triscia** · 07-14-2014, 10:37 AM

I need to get a fix around to be able to combine multiple cells with line breaks. I am unable to get the addin MCONCAT, so I have to find another way around combining. In one cell I need to have A1 & A2 on the next line I need to have B1 & B2, next line C1 & C2. I can get it all in the cell, but i need each set to be a different line. Is there a way to do that? TIA
Trish

**Rob Kennedy** · 07-14-2014, 10:47 AM

Triscia

Easy, try the following:

Please Login or Register  to view this content.

And the two critical things are: you need to put an Alt+Enter between the double speech marks to create the line break, then you need to format the cells to 'Wrap Text'.