Joins exactly two strings or values together. It is similar to &.
=CONCAT(A1, B1) returns the contents of A1 immediately followed by B1.
