Concatenate Strings (Two or More) in Google Sheets

In Google Sheets, multiple ways exist to concatenate two more strings in a single cell. And in this tutorial, you are going through some of the most important ways to do this.

The Best Way to Combine Strings – TEXTJOIN

You need to follow below steps:

1. First, enter the TEXTJOIN function in a cell.
2. In the first argument, enter a space using double quotation marks (“”).
3. Next, in the second argument, enter the TRUE to ignore empty cells.
4. After that, in the third argument, refer to the range from where you want to combine the strings.
5. In the end, close the function and hit enter to get the result.

The moment you hit enter, it returns a new string by combining the range and using a space in between.

=TEXTJOIN(" ",TRUE,A1:A2)

Using Ampersand Operator

Below are the steps to write this formula:

1. Type = in a cell.
2. Refer to the cell with the first value.
3. Enter the & (ampersand).
4. Refer to the cell with the second cell.
5. Hit enter to get the result.

And if you want to add a space in between the strings.

=A1&" "&A2

Using CONCATENATE and CONCAT Functions

With the CONCATENATE function, you can refer to the range from where you want to combine strings.

The only problem you will face is that adding a space between the strings is hard to get a clear combined string in the result. And CONCAT only combines two values, not more than that. And that makes it a little less favourite way to combine values.

=CONCAT(A1,A2)

From all the methods we have used, I suggest you use the first method (TEXTJOIN), which is the most flexible method.

⮞ Get the Sample Sheet