Kč - Kč £ - £ £ - £ £ - £ £ - £ £ - £ ( ) ( ) £ - £ £ - £ € - € R$ - R$ € - € \ \- \ \- \ \- \ \- $ ($ ) $ ($ ) $ ($ ) $ ($ ) - - \ \ - \ - - - \ \ - \ - : : : : Lt - Lt kr - kr € - € SFr. SFr. - . . / / - - - - : : : : : : / / : ( ) ( ) ( ) ( ) ( ) ( ) ??? Page 1 ??? (???) 00/00/0000, 00:00:00 Page 1 / 99 TEXTJOIN Function Result TRUE Sheet Result Description 1 TRUE Simple TEXTJOIN formulas with local references and values Function Expected Correct FunctionString Comment Currency A's B's City State Postcode Country The sun will come up tomorrow. The sun will come up tomorrow. TRUE =TEXTJOIN(" ",1, "The", "sun", "will", "come", "up", "tomorrow.") US Dollar a1 b1 Tulsa OK 74133 US US Dollar, Australian Dollar, Chinese Yuan, Hong Kong Dollar, Israeli Shekel, South Korean Won, Russian Ruble US Dollar, Australian Dollar, Chinese Yuan, Hong Kong Dollar, Israeli Shekel, South Korean Won, Russian Ruble TRUE =TEXTJOIN(", ", 1, I2:I8) Australian Dollar a2 b2 Seattle WA 98109 US a1, b1, a2, b2, a4, b4, a5, b5, a6, b6, a7, b7 a1, b1, a2, b2, a4, b4, a5, b5, a6, b6, a7, b7 TRUE =TEXTJOIN(", ", 1, J2:K7) Chinese Yuan a4 b4 Iselin NJ 8830 US a1, b1, a2, b2, a4, b4, a5, b5, a6, b6, a7, b7 a1, b1, a2, b2, a4, b4, a5, b5, a6, b6, a7, b7 TRUE =TEXTJOIN(", ", 0, J2:K7) Hong Kong Dollar a5 b5 Fort Lauderdale FL 33309 US Tulsa,OK,74133,US;Seattle,WA,98109,US;Iselin,NJ,8830,US;Fort Lauderdale,FL,33309,US;Tempe,AZ,85285,US Tulsa,OK,74133,US;Seattle,WA,98109,US;Iselin,NJ,8830,US;Fort Lauderdale,FL,33309,US;Tempe,AZ,85285,US TRUE =TEXTJOIN(L8:O8, 1, L2:O7) Israeli Shekel a6 b6 Tempe AZ 85285 US OKWA OKWA TRUE =TEXTJOIN(,1,M2,M3) South Korean Won a7 b7 OKWA OKWA TRUE =TEXTJOIN("",1,M2,M3) Russian Ruble , ; OK WA OK WA TRUE =TEXTJOIN(" ",1,M2,M3) OKFunctionWA OKFunctionWA TRUE =TEXTJOIN(A1,1,M2,M3) OK1WA OK1WA TRUE =TEXTJOIN(1,1,M2,M3) OKWA OKWA TRUE =TEXTJOIN(,,M2,M3) A-C A-C TRUE =TEXTJOIN("-",1,I13:K13) A 0 C AC AC TRUE =TEXTJOIN(F14;0;I14:J14) A C