Formula that does Alt-Enter IF cell is populated

[guybrown]

Hello. Please help.

I am concatenating a range of cells into a single cell with a new line for each cell that I am adding. I am using Alt-enter while writing the formula to add a new line. This works fine except if there is an empty cell it leaves a blank line in the concatenated cell.

I want:

dog
cat
egg

I'm currently getting:

dog
cat
___ (blank)
egg

Is there a way to only perform Alt-Enter if cell is populated?
My current formula looks like this:

=IF(EO5="","",EO5&"
"&IF(EP5="","",EP5&"
"&IF(EQ5="","",EQ5)))

Any help much appreciated.

Guy

 

[Aladin Akyurek]

Try...

=SUBSTITUTE(IF(EO5="","",EO5&"#")&IF(EP5="","",EP5&"#")&IF(EQ5="","",EQ5),"#",CHAR(10))

And activate "Wrap text" for the formula cell.

 

[guybrown]

awesome. thank you very much

 

[Aladin Akyurek]

awesome. thank you very much

You are welcome. Thanks for providing feedback.