Thread: Custom Validation starting with 2 char & total less than 8 charact
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
  
Posts: 8,651
Default Custom Validation starting with 2 char & total less than 8 charact
=AND(LEN(A1)<=8,LEFT(A1,2)="AD")
--
David Biddulph

"carusso" wrote in message
...
Can a custom data validation formula be written for a cell to only allow a
user to enter a maximum of 8 characters (<=8) AND begin with the letters
AD?

Thanks!

--
carusso


Reply With QuoteReply With Quote