Excel function to combine multiple cells into one separated by comma. This is the quick way to combine cells separated by any specified delimiter.
Use TEXTJOIN() function, which combines the text from multiple cells or ranges separated by the specified delimiter (comma, semi colon or any other).
Syntax of TEXTJOIN function
TEXTJOIN(delimiter, ignore_empty, text1, [text2], …)
delimiter* – comma(,), semicolon(;), colon(:) etc
ignore_empty* – if TRUE, ignores empty cell values
Note: set ignore_empty to FALSE if you want to include empty cells
text1*, [text2], … – select the cells you want to combine, or mention the cell numbers Ex: A1,B1,C1, E1, F23, A8:N8
TEXTJOIN Function Examples
Example 1: Combine rows into one cell separated by comma, range of cells
Example 2: Separated by comma, include empty cells
Example 3: Combine random cells
Check combine multiple columns in excel into one column [Excel VBA]
References: Microsoft excel