Data validation

[Closed]
Report
Posts
1
Registration date
Friday November 28, 2014
Status
Member
Last seen
November 28, 2014
-
I want a sheet of income tax calculation, so i like a input a cell pan no. so allow in cell LENTH 10 DIGIT AND first five text and mid four number and last ane text For exm. My pan no. -BPGPS1184D
TEXT DATA CPITAL IS AUTOMITIC HO
HOW CREATE FORMULA IN DATA DALIDATION CUSTEM
PLZ TELL ME