Need to take text from multiple columns in the same row and put it into a single cell, but I would like line break (alt enter) between all of the text

[jetedf001]

I have multiple columns of text date that I would like to have in a single cell. So, normally I would have a formula that looks something like this:

=E3&", "&F3&", "&G3

Can I insert a line break (alt enter) instead of the ", " somehow?

 

[Fluff]

How about
=E3&char(10)&F3&char(10)&G3

 

[jetedf001]

How about
=E3&char(10)&F3&char(10)&G3

That gives me a #value! cell. Not every cell has text, so the first cell might have text and be the only cell with text, or there could be multiple cells with text.

 

[jetedf001]

I also tried:

=TEXTJOIN(CHAR(10),1,E3:G3)

but everything is just stuck together, so it reads.
Column1textColumn2textColumn3text

 

[Fluff]

You need to turn "Wrap Text" on.

 

[jetedf001]

You need to turn "Wrap Text" on.

Holy cow, do i feel like an idiot! Thank you so much.

 

[Fluff]

You're welcome & thanks for the feedback.