Thread: How do I restrict data as a Letter and three no. e.g. A233, B767
View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.misc
Stefi Stefi is offline
external usenet poster
  
Posts: 2,646
Default How do I restrict data as a Letter and three no. e.g. A233, B767
Use Custom Data validation with this formula (adjust C2 to the real cell):
=AND(LEN(C2)=4,CODE(C2)=65,CODE(C2)<=90,CODE(MID( C2,2,1))=48,CODE(MID(C2,2,1))<=57,CODE(MID(C2,3,1 ))=48,CODE(MID(C2,3,1))<=57,CODE(MID(C2,4,1))=48 ,CODE(MID(C2,4,1))<=57)

Regards,
Stefi


€˛Raja€¯ ezt Ć*rta:

I want to ristrict the user to enter data in a format with One Letter and
three number.

In Access I can use Input Mask. Is there a simliar kind of feature in Excel?

Reply With QuoteReply With Quote