start a new line when using formula CONCATENATE

Occasional Visitor

I need to connect text from several cells but to start a new line for each cell, what should I use [ALT+ENTER  is not working] ?

1 Reply



This is the formula in cell B7 in the attached example.



After entering the formula i right-clicked with the mouse in cell B7 and selected format cells -> alignment -> wrap text. Then i ticked wrap text (Zeilenumbruch). 

alignment wrap text.JPG