2016-12-20T21:01:28.998667961P0D1LibreOfficeDev/5.4.0.0.alpha0$Linux_X86_64 LibreOffice_project/5a20df55ff829978c880b22e0a1f32c35d0ba30f 0 0 42135 8226 view1 2 8 0 0 0 0 2 0 0 0 0 0 85 60 true false 3 14 0 0 0 0 2 0 0 0 0 0 85 60 true false Sheet2 1241 0 85 60 false true true true 12632256 true true true true false false false 1270 1270 1 1 true false 7 false false true true false false false 1270 1270 true true true true true false 12632256 false Lexmark-E352dn en US zh CN :!),.:;?]}¢'"、。〉》」』】〕〗〞︰︱︳﹐､﹒﹔﹕﹖﹗﹚﹜﹞！），．：；？｜｝︴︶︸︺︼︾﹀﹂﹄﹏､～￠々‖•·ˇˉ―--′’” ([{£¥'"‵〈《「『【〔〖（［｛￡￥〝︵︷︹︻︽︿﹁﹃﹙﹛﹝（｛“‘ true true 3 1 true 1 true rgH+/0xleG1hcmstRTM1MmRuAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQ1VQUzpMZXhtYXJrLUUzNTJkbgAAAAAAAAAAAAAAAAAWAAMAzwAAAAAAAAAEAAhSAAAEdAAASm9iRGF0YSAxCnByaW50ZXI9TGV4bWFyay1FMzUyZG4Kb3JpZW50YXRpb249UG9ydHJhaXQKY29waWVzPTEKY29sbGF0ZT1mYWxzZQptYXJnaW5kYWp1c3RtZW50PTAsMCwwLDAKY29sb3JkZXB0aD0yNApwc2xldmVsPTAKcGRmZGV2aWNlPTEKY29sb3JkZXZpY2U9MApQUERDb250ZXhEYXRhClBhZ2VTaXplOkE0AElucHV0U2xvdDpUcmF5MQBEdXBsZXg6Tm9uZQAAEgBDT01QQVRfRFVQTEVYX01PREUPAER1cGxleE1vZGU6Ok9mZg== false 0 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)