Using this formula to combine data from 6 columns. It works but if the cell to the right is blank, or 0, I don't want the last CHAR(10), but having trouble trying to figure out how to stop that...
SUBSTITUTE(
IF(B8=0,"","aa: "&B8&CHAR(10))&
IF(C8=0,"","bb: "&C8&CHAR(10))&
IF(D8=0,"","cc: "&D8&CHAR(10))&
IF(E8=0,"","dd: "&E8&CHAR(10))&
IF(F8=0,"","ee: "&F8&CHAR(10))&
IF(G8=0,"","ff: "&G8),"","")
SUBSTITUTE(
IF(B8=0,"","aa: "&B8&CHAR(10))&
IF(C8=0,"","bb: "&C8&CHAR(10))&
IF(D8=0,"","cc: "&D8&CHAR(10))&
IF(E8=0,"","dd: "&E8&CHAR(10))&
IF(F8=0,"","ee: "&F8&CHAR(10))&
IF(G8=0,"","ff: "&G8),"","")