Combine Data in Multiple Cells Into 1 Cell with Commas

[Gsrgofass]

Hello,

I have over 3,500 cells with an alpha-numeric name in them. Can I combined each alpha numeric name into one cell separating each name with a comma?
Example in B2:B7 into D2. In the real list, these alpha-numeric names can have between 3 to 26 characters within their name.

Thanks!!

 

[fjns]

Hi, total number of characters that a cell can contain: 32,767 characters.

Excel specifications and limits

 

[Joe4]

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

If you have Excel 2019, 2021, or 365, you can use the new TEXTJOIN function, i.e.

=TEXTJOIN(",",TRUE,B2:B7)

 

[Gsrgofass]

Hi, total number of characters that a cell can contain: 32,767 characters.

Excel specifications and limits

That's fine. I can perform what I need to do in chunks. A solution based on my example with suffice.

 

[Gsrgofass]

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

If you have Excel 2019, 2021, or 365, you can use the new TEXTJOIN function, i.e.

=TEXTJOIN(",",TRUE,B2:B7)

I updated the Excel version and my OS, thanks for that.
I'm using Office Professional Plus 2016. I don't think the JOINTEXT is in that release.

 

[Joe4]

I updated the Excel version and my OS, thanks for that.
I'm using Office Professional Plus 2016. I don't think the JOINTEXT is in that release.

That's too bad! It is a lot harder on the older versions.
There are some methods shown here:

Concatenate (Combine) Cells with a Comma / Excel Formula

In this tutorial, you will learn different ways to concatenate (combine) cells with a comma in Excel easy to follow formulas.

excelchamps.com

How to concatenate range/cells with comma, space, line break in Excel?

www.extendoffice.com

Another option would be to try to use VBA.