View Single Post
  #1   Report Post  
archiboy
 
Posts: n/a
Default input masks and validation

when entering data in a cell, i need to restrict users to enter the following
alphanumeric combination and nothing more.

"aa####a", where "a" is an alphabetic character (a-z) and "#" is a number
(0-9)

i cannot figure out the formula to use under the 'custom' section of Data -
Validation

pls help! thanks