View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Wade Wade is offline
external usenet poster
 
Posts: 22
Default 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!