Hi, the following code displays as a single line
If Range("B8").Value = "" Then
Line1 = "Blank."
Else
Line1 = Range("B8").Value & " " & Range("C8").Value
End If
If Range("B9").Value = "" Then
Line2 = "Blank."
Else
Line2 = Range("B9").Value & " " &...