Data validation

Closed
ranwavijay Posts 1 Registration date Friday November 28, 2014 Status Member Last seen November 28, 2014 - Nov 28, 2014 at 09:34 PM
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