String together formula

[detriez]

I am trying to concatenate as follows

If F2 is not null, Concatenate F1 (header) and F2 CHAR(10) Else nothing
If G2 is not null, Concatenate G1 (header) and G2 CHAR(!0) Else nothing
If H2 is not null, Concatenate H1 (header) and H2 CHAR(10) Else nothing

This formula works but I can use help to string them together

=IF(F2<>"",CONCATENATE(F1,F2),"")

 

[Joe4]

Not sure what you are asking. Are you asking how to string all three of these together, like this?

=IF(F2<>"",CONCATENATE(F1,F2),"") & IF(G2<>"",CONCATENATE(G1,G2),"") & IF(H2<>"",CONCATENATE(H1,H2),"")

If that is not what you are trying to do, please explain in more detail.

 

[detriez]

Joe. This is exactly was I was trying to do. I think I kept trying to overcomplicate things.. Thank you for your help

 

[Joe4]

You are welcome.

 

[detriez]

UGH.. Spoke too soon sorry.
This formula only returns I2 if <>"".
I actually need it to return all cells if <>"".
Sorry for not completely testing

=IF(IF(E2<>"",CONCATENATE($E$1,E2)&CHAR(10),"") & IF(G2<>"",CONCATENATE($G$1,G2)&CHAR(10),"") & IF(H2<>"",CONCATENATE($H$1,H2),"")&I2<>"",CONCATENATE($I$1,I2)&CHAR(10),"")

 

[Joe4]

I am not sure I understand what you are saying, but I think you forgot the IF around the I2 part.

 

[detriez]

I hope this is little more clear

Column E: Column F: Column G: Column H: Column I:
123 ABC 987 XYZ

Should result in Cell A2=:
Column E: 123
Column G: ABC
Column H: 987
Column I: XYZ

This one fails "There's a problem with this formula"

=IF(IF(E2<>"",CONCATENATE($E$1,E2)&CHAR(10),"") & IF(G2<>"",CONCATENATE($G$1,G2)&CHAR(10),"") & IF(H2<>"",CONCATENATE($H$1,H2),"")& IF(I2<>"",CONCATENATE($I$1,I2),""))

 

[detriez]

Oh.. I found it.. I had one too many IFs

=IF(IF(E2<>"",CON

 

[Joe4]

Why do you have the whole thing wrapped in an IF statement?
I think it should just be (4 separate IF statements concatenated together):

=IF(E2<>"",CONCATENATE($E$1,E2)&CHAR(10),"") & IF(G2<>"",CONCATENATE($G$1,G2)&CHAR(10),"") & IF(H2<>"",CONCATENATE($H$1,H2),"")& IF(I2<>"",CONCATENATE($I$1,I2),"")

 

[detriez]

Yup... You're right Joe.. I see that.
NOW , it works as expected.
Thanks!