Why don't you just copy the cell contents as a single string and then paste it
into the box in the Data Validation list when you choose List. As long as your
data is comma delimited then it will appear as a vertical list with each value
separately available as a choice.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------



"ssuyog" wrote in message
om...
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?


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.797 / Virus Database: 541 - Release Date: 15/11/2004