Formula to check against a list of valid values
I am importing data into a spreadsheet. I want to check whether certain
columns contain valid data. So if columns A and D, for instance, need to be
"character", I would want to check that the value in any given field is A-Z
or a-z. Is there a quicker way than using "OR" and typing out the 52
possibilities?
|