Svmaxcel
08-23-2017, 08:57 AM
Hi,
I have some column which contains feedback or comments about the interaction.
So, instead of going and reading every column, I want to combine them.
I used the below formula, but not all comments are coming.
Example.
If e2 and f2 are blank and j2and k2 has some data, its getting skipped.
Need your help in solving the issue.
=IF(E2="","",E2&" - ")&IF(F2="","",F2&" --- ")&IF(J2="","",J2&" - ")&IF(K2="","",K2&" --- "&IF(O2="","",O2&" - ")&IF(P2="","",P2&" --- ")&IF(T2="","",T2&" - ")&IF(U2="","",U2&" --- ")& IF(Y2="","",Y2&" - ")&IF(Z2="","",Z2&" --- ")&IF(AD2="","",AD2&" - ")&IF(AE2="","",AE2&" --- ")&IF(AI2="","",AI2&" - ")&IF(AJ2="","",AJ2&" --- ")&IF(AN2="","",AN2&" - ")&IF(AO2="","",AO2&" --- ")&IF(AS2="","",AS2&" - ")&IF(AT2="","",AT2&" --- ")&IF(AX2="","",AX2&" - ")&IF(AY2="","",AY2&" --- ")&IF(BC2="","",BC2&" - ")&IF(BD2="","",BD2&" --- ")&IF(BH2="","",BH2&" - ")&IF(BI2="","",BI2&" --- ")&IF(BM2="","",BM&" - ")&IF(BN2="","",BN2&" --- "))
I have some column which contains feedback or comments about the interaction.
So, instead of going and reading every column, I want to combine them.
I used the below formula, but not all comments are coming.
Example.
If e2 and f2 are blank and j2and k2 has some data, its getting skipped.
Need your help in solving the issue.
=IF(E2="","",E2&" - ")&IF(F2="","",F2&" --- ")&IF(J2="","",J2&" - ")&IF(K2="","",K2&" --- "&IF(O2="","",O2&" - ")&IF(P2="","",P2&" --- ")&IF(T2="","",T2&" - ")&IF(U2="","",U2&" --- ")& IF(Y2="","",Y2&" - ")&IF(Z2="","",Z2&" --- ")&IF(AD2="","",AD2&" - ")&IF(AE2="","",AE2&" --- ")&IF(AI2="","",AI2&" - ")&IF(AJ2="","",AJ2&" --- ")&IF(AN2="","",AN2&" - ")&IF(AO2="","",AO2&" --- ")&IF(AS2="","",AS2&" - ")&IF(AT2="","",AT2&" --- ")&IF(AX2="","",AX2&" - ")&IF(AY2="","",AY2&" --- ")&IF(BC2="","",BC2&" - ")&IF(BD2="","",BD2&" --- ")&IF(BH2="","",BH2&" - ")&IF(BI2="","",BI2&" --- ")&IF(BM2="","",BM&" - ")&IF(BN2="","",BN2&" --- "))