Thread: Use Validation to force specific entry of first 3 characters in st
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ron
 
Posts: n/a
Default Use Validation to force specific entry of first 3 characters in st
What formula should I enter into Category "Custom" of Validatioan to force
user to begin character string with "PR-"? Desired result is "PR-001". I
don't want user to have option to enter "001" or "002", etc., without the
"PR-". Nor do I want them to be able to enter "DR-001".
Reply With QuoteReply With Quote