Concatenate - Skip Blanks

I’m trying to concatenate multiple stings of text (7or so) from various cells that are linked to another workbook using Char(10), so I can force line breaks between each cell.

However, if one of the cells is blank it leaves a huge space between the previous cell and the proceeding cell. Is there anyway to avoid this / skip blanks?

I was thinking of using an If Statement, but that would require to many layers of logic. Any thoughts? I was using the formula below, but now I have to string more cells.

=IF(AL!C619="",LA!C619&CHAR(10)&MS!C619&CHAR(10),IF(LA!C619="",AL!C619&CHAR(10)&MS!C619&CHAR(10),IF(AND(AL!C619="",LA!C619=""),MS!C619,AL!C619&CHAR(10)&LA!C619&CHAR(10)&MS!C619&CHAR(10))))


Thank you in advance for your help!

=Substitute(finalString , Char(10) & Char(10) , Char(10))

apply that formula to your result. It sounds like your problem is when one of the input strings is empty, resulting in a double tab. This turns all those double tabs into a single.