Using LINE BREAK with CONCATENATE.

[S.H.A.D.O.]

Good afternoon,

Can anyone please tell me why the following formula will not put a line break at the end of the first two statements please (like ALT-ENTER when in a single cell)?

=CONCATENATE("Title ",
TEXT(INDEX($B$18:$B$2517,MATCH(E$10,E$18:E$2517,0)),"#,###,##0"),CHAR(10),
LEFT(INDEX($C$18:$C$2517,MATCH(E$10,E$18:E$2517,0)),3),CHAR(10),
TEXT(INDEX($D$18:$D$2517,MATCH(E$10,E$18:E$2517,0)),"dd mmm yyyy"))

Thanks in advance.

 

[Marcílio_Lobão]

S.H.A.D.O., Good afternoon.

I believe that your formula is OK!

"...(like ALT-ENTER when in a single cell)?..."
When we do this, EXCEL inserts a CHAR(10) as you said, BUT at same time format cell to WRAP TEXT.

Note: make sure you have text wrap enabled on cells that contain line breaks.

I hope it helps.

 

[S.H.A.D.O.]

Thanks for the reply, it is appreciated.
I forgot the WRAP TEXT, all working good now.

Thanks again.

 

[Marcílio_Lobão]

S.H.A.D.O, Good afternoon.

Happy to have helped you.

Have a nice day!