In Google Sheets, just like a comma, you can use any separator to concatenate two or more values. In this tutorial, we will learn all the methods to write a formula for this.
Using TEXTJOIN to Combine Values with Separator
You can use the below steps to write this formula:
- First, enter TEXTJOIN in a cell.
- Now, enter the delimiter to use a separator. Here we have used a space.
- After that, enter TRUE to tell the function to ignore empty cells.
- Next, refer to the range of cells which you want to concatenate.
- In the end, close the function and hit enter to get the result.
And the moment you hit enter, combine the values from the range and the separator you defined.
=TEXTJOIN(" ",TRUE,A1:A3)Alternate Methods
Apart from the TEXTJOIN, you can use the CONCATENATE function + ampersand (&) to combine values with the separator. Below is an example to help you understand this.
=CONCATENATE(A1," ",A2," ",A3)=A1&" "&A2&" "&A3