Hi All,
PFA my small file with formula to check whether PAN is valid or not.
Conditions checked:
Length should be 10,
First 5 character should be text,
Next 6-9 character should be number,
Last character should be text,
4th character should be "P",
No special character including space allowed.
If you like the same then comment or like.
Please show error if any by replying here.
Regards// Vaibhav #xls