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

In Google Sheets, if you want to link data from multiple cells together, you don’t have to merge them. You can use the CONCAT, CONCATENATE, and JOIN functions to combine them in one cell. These functions range from the simplistic (CONCAT) to the complex

To combine text from two or more cells into a single cell, use the CONCATENATE function, which you may enter in Google Sheets on the web (Figure D) as well as the mobile apps. This lets you ...