View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
William William is offline
external usenet poster
 
Posts: 119
Default LIMITING DATA VALIDATION ENTRIES

I have a column that needs to be exactly 10 characters long, with some of the
characters alpha and some numeric. I can do this easily enough be selecting
Data/Validation/Text/equals/10. But is there a way that I can ALSO limit the
characters entered to alpha numeric, but without allowing "funky" characters
such as those on the top row of the keyboard: !@#$%^&*()_+?

Thanks for ideas!
--
William