Hello,
I'm trying to add Data Validation to 50 cells in a column that will only accept:
I did find some examples, but they are all for a single cell. If I try to change it to a range it breaks and won't let me save.
I tried this: =ISNUMBER(SUMPRODUCT(SEARCH(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1),"0123456789abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ-")))
Which works for cell A1. However, if I change A1 to anything else - it won't let me even save the formula. And I need a range instead - O2:O50.
Here is how I am trying to do it:
Thank you so much in advance!
I'm trying to add Data Validation to 50 cells in a column that will only accept:
- Alphanumeric
- Hyphens (dashes)
I did find some examples, but they are all for a single cell. If I try to change it to a range it breaks and won't let me save.
I tried this: =ISNUMBER(SUMPRODUCT(SEARCH(MID(A1,ROW(INDIRECT("1:"&LEN(A1))),1),"0123456789abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ-")))
Which works for cell A1. However, if I change A1 to anything else - it won't let me even save the formula. And I need a range instead - O2:O50.
Here is how I am trying to do it:
- Select a range of cells I need apply validation to, which O2:O50
- Click on Data Validation
- Select Custom Data validation and enter a formula above into the Formula entry.
Thank you so much in advance!