single-cell multiple entry with pull-down list?
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!
|