Concatenate Function
The Concatenate function allows you to join the contents of cells in Sheets.
What it does?
Joins (appends) the contents of cells.
Syntax
=CONCATENATE(cellref,cellref)
=CONCATENATE(“text”,” “,”text”,” “,”text”)
=CONCATENATE(cellref:cellref)
Examples
=CONCATENATE(A1:G1)
=CONCATENATE(“Hello”,” “,”From”,” “,”Just Click Here”)
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.