How to ignore cells while concatenating cells in Excel

[Jenn1981]

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

 

[bosco_yip]

Maybe, in D2 copied down :

=IF(A2="n","",CONCATENATE(A2,B2,C2))

or,

=IF(A2="n","",A2&B2&C2)

Regards
Bosco

 

[Jenn1981]

This is great Bosco. Thank you.

 

[Jenn1981]

Maybe, in D2 copied down :

=IF(A2="n","",CONCATENATE(A2,B2,C2))

or,

=IF(A2="n","",A2&B2&C2)

Regards
Bosco

Hi Bosco,
What if I added another column. for example, if A is N or D is blank. Don't concate that row.

 

[p45cal]

=IF(OR(A2="n",ISBLANK(D2)),"",A2&B2&C2)

 

[bosco_yip]

Or this shorter,

=IF(OR(A2={"n",""}),"",A2&B2&C2)

Regards
Bosco

 

[p45cal]

Bosco,

or D is blank

 

[bosco_yip]

Bosco,

Sorry, misreading

Maybe,

=IF((A2="n")+(D2=""),"",A2&B2&C2)

Regards
Bosco

 

[chirayu]

=IF(OR(A2="N",D2=""),"",A2&B2&C2)

 

[snjpverma]

=IF(A2&D2="n","",A2&B2&C2)