If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Merge data from multiple cell with the conditiion that only if the cell has data in it as well as add HTML list element

Thread starter yarajani
Start date May 22, 2019
Tags

concatanate data html element if condition statement result

yarajani

New Member

May 22, 2019

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