I'm trying to join 30 individual text stings (each in a different cell, so concatenate might work) into one cell to facilitate printing. My goal is for the final cell to contain all of the original strings, each separated by a line return, with extra space from empty cells eliminated (to print as part of a report). I'm also working with Excel 2008 for the mac which no longer supports macros (ARGH!!).

Any thoughts would be appreciated!