CODEWITHSUNDEEP
excel-formula
Dave Iammarino
Dave Iammarino

Reputation: 1

Using TEXTJOIN adding "and" between

using=TEXTJOIN(",",TRUE,D2, "and",I2) this works were there is a value in I, How do I eliminate the "and" when there is not a value in I?

Upvotes: 0

Views: 53

Answers (1)

Scott Craner
Scott Craner

Reputation: 152505

use:

=TEXTJOIN(",",TRUE,D2, IF(I2<>"","and,"& I2,""))`

Upvotes: 1

Related Questions