Need to concatenate multiple cells if a condition is met

**Gssoc777** · 09-24-2015, 03:28 PM

Good Afternoon!

First time posting so I apologize if I do anything wrong.

I am looking to =concatenate($A$1,A2,B3,$C$1,C2,B3,$D$1,D2,B3) ETC. so it would look like this:

<li>Weight:155 <li>Dimensions:84" x 48" x 32" (HxWxD) <li>Warranty:1 Year Parts and Labor <li>Electrical:11v,NEMA 5-15P

Here is the catch: Notice how this formula would completely skip concatenating E1,E2 and B3 because there is no value in E2. That's what I want this formula to do. Skip concatenating if there is no value in a certain cell. Another way to say it is only concatenate the 3 specified cells if there is a value in row 2.

Perhaps there is a Way easier way to do this. Perhaps this is impossible I am hoping to get an answer either way. Thanks!

Spreadsheet.jpg

**Kaper** · 09-24-2015, 04:00 PM

in B4:

Formula:

Please Login or Register  to view this content.

and copy right.
in G4 you will have final output.

**Gssoc777** · 09-24-2015, 04:53 PM

Thanks Very much Kasper. I used the formula for each one of my titles and concatenated the results together into a final cell to get the string I wanted!

Would you mind explaining the logic behind this formula? I am very interested to know how it worked!

**Kaper** · 09-25-2015, 08:21 AM

A4 is empty. We start from B4
Our formula can be written as:

Formula:

Please Login or Register  to view this content.

and If is:

Formula:

Please Login or Register  to view this content.

so for each column we concatenate the string collected so far with the part from cells above and B3
or (if one or both cells above were empty) simply rewrite contents of left cell (concatenate it with empty string).