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!

Please Login or Register  to view this content.

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.