Using Char(10) With CONCATENATE & IF Statements

Is there any way to make this work without using VBA? I'm not near as good with VBA and it takes a lot longer for me to figure out.

Here is what I have...

=CONCATENATE(IF(ISBLANK(R725),"",R725&CHAR(10)),IF(ISBLANK(S725),"",S725&CHAR(10)),IF(ISBLANK(N725),"
",N725))

It works just fine unless one of the cells is blank. It still puts in the return. I've tried several different ways and just can't figure it out. Any guidance is greatly appreciated!

Cancel this. I simply removed the isblank and it works fine.

This is what I have now..

=CONCATENATE(IF(R735="","",R735&CHAR(10)),IF(IS735="","",S735&CHAR(10)),IF(N735="","
",N735))

I don't find CONCATENATE very useful, and tend to just use & instead. e.g.

=(IF(R735="","",R735&CHAR(10))&IF(IS735="","",S735&CHAR(10))&IF(N735="","",N735))

I suspect your original problem might have been due to the difference between empty cells and cells with a formula that results in a blank value (e.g. a formula that results in ""). ISBLANK returns true for the former but FALSE for the latter.