View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Stephen[_2_] Stephen[_2_] is offline
external usenet poster
 
Posts: 364
Default single-cell multiple entry with pull-down list?

It's not possible. You could have multiple columns and choose different ones
in each (with a formula in another column to concatenate them if necessary).

"Wade" wrote in message
...
Hello,

I've been scouring all the tutorials and forums to see if it's possible to
have multiple entries in a single-cell with a pull-down list.

For ex. the pull-down list is composed of: Object A, Object B, ..., Object
X
When I click on a cell with the data validation-List enabled, I currently
have the option of choosing Object A OR Object B, etc.
But I can't pick Object A, then input comma in the same cell, then select
Object B in the same cell (i.e. in one cell, have "Object A, Object B,
etc.")
without the second selection wiping out the first one.

Is this possible in Excel and how can I do this?

Thanks in advance!