Hi Chronos,

Another idea would be to use data validation to only allow selection from a list that you define. Then, with steelmonkey's formula, no entry will give a blank - makes it a bit neater.

Ed