CODEWITHSUNDEEP
excel
Jan4ezz
Jan4ezz

Reputation: 63

Why excel returns #Value! when in TEXTJOIN function one cell exceeds 252 characters?

So i am using TEXTJOIN function in excel and it works great, unless one of the cells which should be joined contains more than 252 characters. 

=TEXTJOIN(", ";TRUE;IF($A$1:$A$20=C1;$B$1:$B$20;""))

So,for example, if cell B2 has 255 characters, it will give me a #VALUE! error.

If the textjoin is without IF function, it works fine even if cells contain more than 252 characters. Why it is so and is there any solution to this problem?

Upvotes: 4

Views: 884

Answers (1)

thing10
thing10

Reputation: 141

This is because the "IF" function only allows cells that have less than 253 characters. If you took the "TEXTJOIN" out, the "IF" would produce a "#VALUE!" error.

Upvotes: 3

Related Questions