IF Statement for Multiple conditions returning the wrong results

[Fernando Salgueiro]

I am trying to get a formula to check if B2 have the first 3 letter and have more than 9 characters if yes check C2 for the same logic if yes add B2&" "&C2 and check D2, if yes add D2 and check e3 and f2. the problem is some of the false statement is returning a false number. See. below the last row it will be form as 3Word & 4Word & 5Word but my if is adding 2word that does not match the ifs

[#2 · Accepted solution]

Fernando,

if I understood correctly:

{=TEXTJOIN(" ",TRUE,IF(ISERROR(--LEFT(B2:F2))*(LEN(B2:F2)>9),B2:F2,""))}

[#3]

Thank you very much