Title: Excel Formula: Combine cells with comma
Headings: Excel Formula: Combine cells with comma
Excel Formula: Combine cells with comma
Formula 1 Combine cells with comma by using &
Generic formula:
Arguments
How this formula work
Explanation
Remark
Formula 2 Combine cells with comma by using CONCATENATE function
Generic formula:
Arguments
How this formula work
Explanation
Remark
Formula 3 Combine cells with comma by combining SUBSTITUTE and TRIM functions
Generic formula:
Arguments
How this formula work
Explanation
Remark
Combine cells with other separators
Sample File
Relative Formulas
The Best Office Productivity Tools
Kutools for Excel - Helps You To Stand Out From Crowd
Office Tab - Enable Tabbed Reading and Editing in Microsoft Office (include Excel)

Content: In this case, please choose formula 3. Formula 3 Combine cells with comma by combining SUBSTITUTE and TRIM functions
Generic formula: =SUBSTITUTE (TRIM (text_1&" "&text_2&" "&…&" "&text_n)," ",", ")
Arguments
Text_1, text_2, text_n: the cells or text strings you want to combine with comma. How this formula work
For instance, you want to combine the cell B3, C3, D3 and E3 into one cell with commas, please use below formula in a blank cell. =SUBSTITUTE (TRIM (B3&" "&C3&" "&D3&" "&E3)," ",", ")
Press Enter key, then drag the fill handle down to apply this formula to the cells you need to combine, then the cells are combined with comma separated. Explanation
TRIM function: the TRIM function removes all extra spaces from the text string. Here TRIM (B3&" "&C3&" "&D3&" "&E3) will combine cells with spaces and then clear the extra spaces, this formula will stop the trailing or leading comma. SUBSTITUTE function: