[TABLE="width: 206"]
<tbody>[TR]
[TD="class: xl64, width: 206"][/TD]
[/TR]
</tbody>[/TABLE]
This is working fine.
=CONCATENATE(
IF(E5<>"", ""&$E$3&CHAR(160)&$E$4&CHAR(160)&E5&"
",""),
IF(F5<>"",""&$F$3&CHAR(160)&$F$4&CHAR(160)&F5&"
",""),
IF(G5<>"",""&$G$3&CHAR(160)&$G$4&CHAR(160)&G5&"
",""),
IF(H5<>"",""&$H$3&CHAR(160)&$H$4&CHAR(160)&H5&"
",""),
IF(I5<>"",""&$I$3&CHAR(160)&$I$4&CHAR(160)&I5&"
",""),
IF(J5<>"",""&$J$3&CHAR(160)&$J$4&CHAR(160)&J5&"
",""),
IF(K5<>"",""&$K$3&CHAR(160)&$K$4&CHAR(160)&K5&"
",""),
IF(L5<>"",""&$L$3&CHAR(160)&$L$4&CHAR(160)&L5&"
",""),
IF(M5<>"",""&$M$3&CHAR(160)&$M$4&CHAR(160)&M5&"
",""),
IF(N5<>"",""&$N$3&CHAR(160)&$N$4&CHAR(160)&N5&"
",""),
IF(O5<>"",""&$O$3&CHAR(160)&$O$4&CHAR(160)&O5&"
",""),
IF(P5<>"",""&$P$3&CHAR(160)&$P$4&CHAR(160)&P5&"
",""))
Need to add range from line 5 to line 17 in the result. something like this
IF(E5<>"", ""&$E$3&CHAR(160)&$E$4&CHAR(160)&E5:E18&"
",""),
Not getting any error messge but the result show first line E5
<tbody>[TR]
[TD="class: xl64, width: 206"][/TD]
[/TR]
</tbody>[/TABLE]
This is working fine.
=CONCATENATE(
IF(E5<>"", ""&$E$3&CHAR(160)&$E$4&CHAR(160)&E5&"
",""),
IF(F5<>"",""&$F$3&CHAR(160)&$F$4&CHAR(160)&F5&"
",""),
IF(G5<>"",""&$G$3&CHAR(160)&$G$4&CHAR(160)&G5&"
",""),
IF(H5<>"",""&$H$3&CHAR(160)&$H$4&CHAR(160)&H5&"
",""),
IF(I5<>"",""&$I$3&CHAR(160)&$I$4&CHAR(160)&I5&"
",""),
IF(J5<>"",""&$J$3&CHAR(160)&$J$4&CHAR(160)&J5&"
",""),
IF(K5<>"",""&$K$3&CHAR(160)&$K$4&CHAR(160)&K5&"
",""),
IF(L5<>"",""&$L$3&CHAR(160)&$L$4&CHAR(160)&L5&"
",""),
IF(M5<>"",""&$M$3&CHAR(160)&$M$4&CHAR(160)&M5&"
",""),
IF(N5<>"",""&$N$3&CHAR(160)&$N$4&CHAR(160)&N5&"
",""),
IF(O5<>"",""&$O$3&CHAR(160)&$O$4&CHAR(160)&O5&"
",""),
IF(P5<>"",""&$P$3&CHAR(160)&$P$4&CHAR(160)&P5&"
",""))
Need to add range from line 5 to line 17 in the result. something like this
IF(E5<>"", ""&$E$3&CHAR(160)&$E$4&CHAR(160)&E5:E18&"
",""),
Not getting any error messge but the result show first line E5