Delimiter for Data Validation

  • Thread starter Thread starter Rick De Marco
  • Start date Start date
R

Rick De Marco

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
 
I may be wrong, but I believe that the delimiter used by data validation
comes from Windows' Regional Settings and cannot be customized.
 
If you import the data onto a worksheet, you can refer to that range as
the list source. When a cell in the range contains a comma, the entire
cell will be treated as one item in the list.
 
Back
Top