TrimEnds(Concatenate(
If(Q1_label.Text<>"" && N1.Text<>"", Q1_label.Text & ": " & N1.Text & Char(13), ""),
If(Q2_label.Text<>"" && N2.Text<>"", Q2_label.Text & ": " & N2.Text & Char(13), ""),
If(Q3_label.Text<>"" && N3.Text<>"", Q3_label.Text & ": " & N3.Text & Char(13), ""),
If(Q4_label.Text<>"" && N4.Text<>"", Q4_label.Text & ": " & N4.Text & Char(13), ""),
If(Q5_label.Text<>"" && N5.Text<>"", Q5_label.Text & ": " & N5.Text & Char(13), ""),
If(Q6_label.Text<>"" && N6.Text<>"", Q6_label.Text & ": " & N6.Text & Char(13), ""),
If(Q7_label.Text<>"" && N7.Text<>"", Q7_label.Text & ": " & N7.Text & Char(13), ""),
If(Q8_label.Text<>"" && N8.Text<>"", Q8_label.Text & ": " & N8.Text & Char(13), ""),
If(Q9_label.Text<>"" && N9.Text<>"", Q9_label.Text & ": " & N9.Text & Char(13), ""),
If(Q10_label.Text<>"" && N10.Text<>"", Q10_label.Text & ": " & N10.Text & Char(13), ""),
If(Q11_label.Text<>"" && N11.Text<>"", Q11_label.Text & ": " & N11.Text & Char(13), ""),
If(Q12_label.Text<>"" && N12.Text<>"", Q12_label.Text & ": " & N12.Text & Char(13), ""),
If(Q13_label.Text<>"" && N13.Text<>"", Q13_label.Text & ": " & N13.Text & Char(13), ""),
If(Q14_label.Text<>"" && N14.Text<>"", Q14_label.Text & ": " & N14.Text & Char(13), ""),
If(Q15_label.Text<>"" && N15.Text<>"", Q15_label.Text & ": " & N15.Text & Char(13), ""),
If(Q16_label.Text<>"" && N16.Text<>"", Q16_label.Text & ": " & N16.Text & Char(13), "")
))
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.