View Single Post
  #1   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.programming
ssuyog ssuyog is offline
external usenet poster
 
Posts: 1
Default Convert comma separated string to DropDown

I have one cell which has string "jingo,bingo,tango,mango". In another
cell I want to create drop down list which has jingo, bingo etc as
separate values in the list. Also I dont want to use macros. Is it
possible to create such list just by using available excel functions
and Data Validation dialog box?