Thread: Use Validation to force specific entry of first 3 characters in st
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Peterson
 
Posts: n/a
Default Use Validation to force specific entry of first 3 characters in st
=LEFT(A1,3)="Pr-"
or maybe...
=EXACT("PR-",LEFT(A1,3))

(with A1 being validated.)

ron wrote:

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".

--

Dave Peterson
Reply With QuoteReply With Quote