Add Line Breaks in a Formula

[tigerdel]

Good morning
I am trying to CONCATENATE and have used 2 different formulas:

1. =TEXTJOIN(CHAR(10),TRUE,A2:C2)
2. =CONCATENATE(A2,CHAR(10),B2,CHAR(10),C2)

In both instances I am getting the same result: 123 instead of:
1
2
3

Any ideas??

Many thanks

 

[sandy666]

use wrap text

 

[Yongle]

Try setting Alignment to Wrap Text
@sandy666 got there first ?

 

[tigerdel]

Thanks Guys forgot about Wrap Text

 

[sandy666]

You are welcome