Hello everyone,
I have a drop down with some values. How multiple values can be selected for that drop down and brought into a single cell separated by comma. Any help is appreciated.
Thanks.
Suppose your “drop down” is made using the ‘Data’ > ‘Validity’ feature. There is no multiselection mode for it.
For the task to concatenate entries of a list inserting a delimiter between any two of them, there also was no tool until recently. V5.2.0 introduced the new function TEXTJOIN for the pupose. It is (IMO) not yet implemented with sufficient reliability.
A possible workaround might be to have multiple “drop down” selection cells, example A1, B1, C1 etc, and then join the selected values in a different cell. Use the IF function to avoid inserting extra “,” if one of the cells has no selection.
= A1 & IF(B1<>"","," & B1,"") & IF(C1<>"","," & C1,"")