View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dan[_7_] Dan[_7_] is offline
external usenet poster
 
Posts: 3
Default Data Validation of user input

I need a function to text user input. The input must be 10 characters in
length, consist of 5 digits, 1 letter and then 4 digits (a property barcode).
Examples:
00015D6345
01451A0011
Any other format will get an error message.
Can someone help me?
--
Dan