Hi,
Try widening the col with your concat formulas,
or try formatting the col to wrap text
(Click Format Cells Alignment tab Check "Wrap Text" OK)

Ok, but result in cell is 0 - one single digit. So I made column wider,
I wraped text, but 0 is 0...
Best Regards
Raff