concatenate more column value

[moonhkt]

Hi All

Any function can be simply below function , No VBA? Next time, I will
try add 26 column value.

=IF(TRIM(H2)&TRIM(I2)&TRIM(J2)&TRIM(K2)&TRIM(L2)&TRIM(M2)&TRIM(N2)&TRIM
(P2)&TRIM(Q2)&TRIM(R2)&TRIM(S2)&TRIM(T2)<> "", "Y","N")

moonhkt

 

[Per Jessen]

Hi

This formula should do it:

=IF(SUMPRODUCT(--(TRIM(J2:T2)>""))>0,"Y","N")

or

=IF(SUMPRODUCT(--(LEN(TRIM(J2:T2))>0))>0,"Y","N")

Regards,
Per

 

[moonhkt]

Thank. it works.

Hi

This formula should do it:

=IF(SUMPRODUCT(--(TRIM(J2:T2)>""))>0,"Y","N")

or

=IF(SUMPRODUCT(--(LEN(TRIM(J2:T2))>0))>0,"Y","N")

Regards,
Per

"moonhkt" <[email protected]> skrev i meddelelsen






- Åã¥Ü³Q¤Þ¥Î¤å¦r -

 

[Bob Phillips]

.... or

=IF(SUMPRODUCT(--(LEN(TRIM(J2:T2))>0)),"Y","N")

Bob