Moving between lines within a Cell

[Benny Francis]

Good day All,

I have used Char(10) to move data to new line within a cell, but I want to build a formula that will, be based on an "if" proposition, that should the value of cell X be equal to "0" then the formula will not move to the next new line.

Please assist.

 

[chirayu]

So you want to count number of Char(10)?

 

[Xiq]

Hi Benny Francis,

How about this:

=IF(value of cell X=0,CHAR(10),"")