View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Illya Teideman Illya Teideman is offline
external usenet poster
 
Posts: 26
Default Restricting data entry to A-Z a-z 0-9

Is there an easy way of restricting the data that can be entered into a cell
so that only characters that are in the range A to Z a to z 0 to 9 are valid.
i.e !"£$%^&*()-_ etc etc are not allowed? Might also need space to be an
allowed character, not sure yet.