Helps you merge cells
Concatenate Function in Google Sheets
The CONCATENATE function in Google Sheets joins multiple pieces of data together. This function is useful for managing large amounts of information that all need to be treated similarly.
For example, you might use the CONCATENATE function if your spreadsheet has one column for a first name and another for a last name, but you want them to be merged into one cell with both names. You can do this manually by typing in each name, or you can use CONCATENATE to automate it.
There are many more examples of the CONCATENATE function. Below we will look at a few.