CONCATENATE

The CONCATENATE formula is used to combine text from multiple cells into one cell. To use the CONCATENATE formula, select the cell where you want the result to appear and enter “=CONCATENATE(” followed by the cells you want to combine separated by commas. For example, “=CONCATENATE(A1,B1)” would combine the text in cells A1 and B1 into one cell.

Example:

Combine the text in cells A1 and B1: =CONCATENATE(A1,B1).