Perhaps you could enter the formula in an adjacent cell, then refer to
that cell in the data validation formula box.

amit wrote:
I am trying to generate "Drop down list" using formula.

The path I am using is :

Data Validation ---List ----Formula

It seems there is limitation on no. of characters, which could be
typed in this FORMULA field.

Can someone help me in generating the list using someother technic.

Thanks in advance for your replies.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html