I have many times I am creating drop down lists in Excel in which I have to concatenate many cells (with a comma between them). There is always an error returned due to the length.
Can anyone help witha formula for this? Using a separate list in another location is not an option.

Thank you so much in advance.