Comparison of Google Sheets JOIN, TEXTJOIN, and CONCATENATE Functions. I am using all the above three text join functions – JOIN, TEXTJOIN, CONCATENATE Functions – and the fourth one, “&”, to join the texts below. See how each formula differ.

That is, CONCATENATE(A2:B7) is equivalent to CONCATENATE(A2,B2,A3,B3, ... , A7,B7). See Also. SPLIT: Divides text around a specified character or string, and puts each fragment into a separate cell in the row. JOIN: Concatenates the elements of one or mor

The CONCATENATE function is more complex than CONCAT. It offers more flexibility for those who want to combine cell data in different formats. For example, CONCAT doesn’t allow you to add additional text or spaces, but CONCATENATE does. To use CONCATENA