When you want to join cell data of columns and rows in Google Spreadsheet, you can use “& (Ambasand)” to join them, but this function can be used when you want to join multiple columns together.
![](https://eguweb.jp/wp-content/uploads/202210162340-00-1024x377.jpg)
![](https://eguweb.jp/wp-content/uploads/202210162340-01-1024x299.jpg)
CONCAT Function
The CONCAT function can be used to combine multiple ranges or strings of text.
CONCAT(text1, [text2],...)
However, with the CONCAT function, an error is displayed when a range is specified.
![](https://eguweb.jp/wp-content/uploads/202210162348-00.jpg)
![](https://eguweb.jp/wp-content/uploads/202210162348-01-1024x273.jpg)
The CONCATENATE function is a function that can be used in such cases.
CONCATENATE Function
The CONCATENATE function can be used to combine two or more strings into a single string.
CONCATENATE(string 1 [string 2], ...)
The CONCATENATE function allows a range to be specified.
![](https://eguweb.jp/wp-content/uploads/202210162349-00-1024x264.jpg)
We were able to link them all at once!
![](https://eguweb.jp/wp-content/uploads/202210162350-00-1024x429.jpg)
TEXTJOIN Function
The TEXTJOIN function can also be used for merging.
TEXTJOIN(delimiter, ignore empty cells, text 1, [text 2, ...])
The first argument is blank, the second argument is true, and the third argument is a range.
![](https://eguweb.jp/wp-content/uploads/202210170009-00-1024x311.jpg)
Then the specified range is combined.
![](https://eguweb.jp/wp-content/uploads/202210170009-01-1024x394.jpg)
summary
The CONCATENATE function is useful for concatenating column values all at once.
Please refer to 😃.