Excel combine multiple cells into one separated by comma [Quick Way]

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 of textjoin function, separated by comma

Example 2: Separated by comma, include empty cells

example of textjoin function, inclue empty cells

Example 3: Combine random cells

example of combine random cells in excel separated by comma

Check combine multiple columns in excel into one column [Excel VBA]

References: Microsoft excel

About the Author

SRINI S

A passionate blogger. Love to share solutions and best practices on wordpress hosting, issues and fixes, excel VBA macros and other apps

Leave a Reply

Your email address will not be published.