If you place your long strings, say, in A1,A2,A3 cells, then select range
A1:A3 and name it, say, longstrings, then typing =longstrings in Data
validation/List Formulas field will give you the required result. Apply a
suitable column width for the validated cell to make the whole long string
visible in the drop down list!

Regards,
Stefi

€žWerner Rohrmoser€� ezt Ã*rta:

Stefi,

thanks your suugestion, but I have 3 long strings like
"Production Calendar STUS / 5.67 days a week".
It seems that the total lenghth of all of them is too long.

T name a range and to use this name is an other option, but
I like to know if it is possible to use named arrays in validation
list.

Werner