Ask Your Question

How multiple values can be selected in a drop down and pasted in a single cell? [closed]

asked 2016-08-19 12:57:43 +0200

shilpibanerjee1 gravatar image

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.


edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2020-09-10 17:35:57.796335

2 Answers

Sort by » oldest newest most voted

answered 2016-08-19 13:20:11 +0200

Lupp gravatar image

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.

edit flag offensive delete link more

answered 2016-08-19 18:21:25 +0200

mark_t gravatar image

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,"")
edit flag offensive delete link more

Question Tools

1 follower


Asked: 2016-08-19 12:57:43 +0200

Seen: 931 times

Last updated: Aug 19 '16