Concatenate Function

The Concatenate function allows you to join the contents of cells in Sheets.

What it does?

Joins (appends) the contents of cells.



=CONCATENATE(“text”,” “,”text”,” “,”text”)




=CONCATENATE(“Hello”,” “,”From”,” “,”Just Click Here”)

JCH Example of concatenate in sheets

If you click on the download button below, you will be asked if you want to download a copy of the examples used on this page into Sheets.

I hope you enjoyed reading about the concatenate function in Sheets. Other text functions in Sheets include Proper, Upper, Lower (which allow you to use a function to change the case of text) LEFT, RIGHT, SPLIT, CLEAN, TRIM, JOIN and MID, among many others. If you want to return to the resources page, just click here.