Hi,

I have data validation set up on a cell which has my validation
criteria set to be a List. Everything is working fine for me except
when the data (coming from a database) I am creating the list from has
a comma, the list then treats it as a new entry even though its not.

Is there a different delimiter you can use in a validation list apart
from a comma? Are you able to specify it via code?

Cheers,

Rick