Join cells with comma in Excel

This is to connect several cells together and separate them with a comma.

Use ampersand operator and and SUBSTITUTE function

Ampersand (&) operator is used to join values of defined cells. If the number of cells is limited, use this operator is fast.

After connecting cells with & operator, we use SUBSTITUTE function to replace certain text with a comma. In our case, it is blank space.

=SUBSTITUTE(A2&" "&A3&" "&A4&" "&A5&" "&A7&" "&A7&" "&A8," ",", ")

Result

Shanelle, Lily, Garrett, Madeline, Christophe, Christophe, Joe

Use TEXTJOIN function

This is a new function available in Office 365 and Excel 2019. It can concatenate a range of cells with a delimiter.

=TEXTJOIN(", ",TRUE,A1:B3)

Result

First Name, City, Shanelle, South Vadatown, Lily, North Titusville

Leave a Comment

Your email address will not be published. Required fields are marked *

We care about your privacy and data security. Google serves cookies to analyse traffic and show ads on this site. By using this site you agree to these cookies being set. more information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.

Close