I've updated the sample file, and added a sample formula he

http://www.contextures.com/xlDataVal02.html

in the Using Dynamic Lists section

Steve_n_KC wrote:
Thank You Very Much! I KNEW I had seen a fix for my problem on your site
(which is WONDERFUL btw) but couldn't find it when I looked for it yesterday.

Is it possible to nest the validation formula that you give for removing the
spaces into the validation formula for Dynamic Lists?

I tried several different ways of writing it but never got close enough for
Excel to suggest an alternative.

Either way, Thanks again!


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html