Title: How to Combine Cells With Comma in Excel
Headings: How to Combine Cells With Comma in Excel
How to Combine Cells With Comma in Excel
Example: Join Cell Values of Ranges With Comma as Delimiter
How does it work?
Concatenating Cells with Commas in Excel 2016 and Older
Related Articles:
Popular Articles:
Previous

Content: =TEXTJOIN(",",TRUE,B3: E3,B7: E7)
It will concatenate all the texts ignoring the blank cells. How does it work? The formula is simple. The TEXTJOIN function requires the delimiter with which you want to join text with. The second variable is set to be true so that it ignores the blank cells. Now if any cell has invisible values like space then you will see an extra comma in between the joined text. To avoid spaces, use the TRIM function to strip them out. =TEXTJOIN(",",TRUE,TRIM(B3: