View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Barb W[_2_] Barb W[_2_] is offline
external usenet poster
 
Posts: 1
Default 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?