How to ignore cells while concatenating cells in Excel

[Jenny310]

Hi. I'm trying to concat Cell A, B, and C. However, I don't want to concat the row if column A has "N".
For example, below I would like to skip 4and 5 because column A has "N".


****** id="cke_pastebin" style="position: absolute; top: 0px; width: 1px; height: 1px; overflow: hidden; left: -1000px;">Hi. I'm trying to concat Cell A, B, and C. However, I don't want to concat the row if column A has "N".
For example, Below I would like to skip row 4 and 5 because column A has "N". (Highlighted in yellow)

Thanks,
Jenny</body>

A	B	C	Concate
y	Dodge	c100	yDodgec100
y	Cap	c101	yCapc101
n	Circus	c102	nCircusc102
n	Warren	c103	nWarrenc103
y	Tooker	c104	yTookerc104
y	Dodge	c100	yDodgec100

<colgroup>







</colgroup><tbody>
</tbody>

 

[Trebor76]

Hi Jenny310,

Welcome to MrExcel!!

Assuming the data starts in Row 1, put this in cell D1...

=IF(A1="n","",A1&B1&C1)

...and copy it down as far as you need it.

HTH

Robert

 

[Jenny310]

Works Great. Thank you Robert.

Hi Jenny310,

Welcome to MrExcel!!

Assuming the data starts in Row 1, put this in cell D1...

=IF(A1="n","",A1&B1&C1)

...and copy it down as far as you need it.

HTH

Robert

 

[Trebor76]

Thanks for letting us know and you're welcome

 

[Jenny310]

Hi Robert, Sorry, one more question.
I added another column.
If column A is "N" or Column D is blank don't concate the row.

A	B	C	D	Concate
y	Dodge	c100	yard	yDodgec100
y	Cap	c101	fence	yCapc101
n	Circus	c102
n	Warren	c103
y	Tooker	c104	dog	yTookerc104
y	Dodge	c100	fence	yDodgec100

<colgroup><col><col><col span="2"><col></colgroup><tbody>
</tbody>

 

[philwojo]

Try this:

[COLOR=#333333]=IF(or(A1="n",D1=""),"",A1&B1&C1)[/COLOR]

 

[Jenny310]

Thank you Phil.