Kč - Kč £ - £ £ - £ £ - £ £ - £ £ - £ ( ) ( ) £ - £ £ - £ € - € R$ - R$ € - € \ \- \ \- \ \- \ \- $ ($ ) $ ($ ) $ ($ ) $ ($ ) - - \ \ - \ - - - \ \ - \ - : : : : / / - - - - : : : : : : / / : ( ) ( ) ( ) ( ) ( ) ( ) ??? Page 1 ??? (???) 00/00/0000, 00:00:00 Page 1 / 99 CONCATENATE Function Result TRUE Sheet Result Description 1 TRUE Simple CONCATENATE formulas with local references and values Function Expected Correct FunctionString Comment Data cat Good Morning Mrs. Doe Good Morning Mrs. Doe TRUE =CONCATENATE("Good ","Morning ","Mrs. ","Doe") brook trout Andreas Hauser dog Stream population for brook trout species is 32/mile. Stream population for brook trout species is 32/mile. TRUE =CONCATENATE("Stream population for ", I2, " ", I3, " is ", I4, "/mile.") species Fourth Pine mouse brook trout Andreas brook trout Andreas TRUE =CONCATENATE(I2, " ", J2) 32 #VALUE! AOO 117662 Andreas, brook trout Andreas, brook trout TRUE =CONCATENATE(J2, ", ", I2) Fourth & Pine Fourth & Pine TRUE =CONCATENATE(J3, " & ", K3) 1 1 TRUE =CONCATENATE(TRANSPOSE(1)) 4