SOLVED

combine multiple cells into one cell

Iron Contributor

Hi
I want to combine multiple cells into one cell separated by "," as explained in the attached file.
Thx.

2 Replies
I use eg =A1&","&A2&","&A3
best response confirmed by ajl_ahmed (Iron Contributor)
Solution

@ajl_ahmed 

You can use TEXTJOIN:

 

=TEXTJOIN(", ",,C10:C13)
1 best response

Accepted Solutions
best response confirmed by ajl_ahmed (Iron Contributor)
Solution

@ajl_ahmed 

You can use TEXTJOIN:

 

=TEXTJOIN(", ",,C10:C13)

View solution in original post