Validating PAN NUMBER Indian Format

[mani780]

Hi,

How to use Data Validation on PAN NUMBER,

The cell should take only if it is in such format.

[Admin]

Hi

Welcome to board!!!

See http://www.excelfox.com/forum/f13/validating-pan-indian-format-409/?highlight=validate+number

[mani780]

Hi

Welcome to board!!!

See http://www.excelfox.com/forum/f13/validating-pan-indian-format-409/?highlight=validate+number

Hi,

if i use the formula that u have suggested shows an error like " You may not use unions, intersections, or array constants for data validation criteria "

What is the solution.

[Admin]

If the PAN is in A2, enter this formula in B2

=AND(COUNT(MID(A2,{6,7,8,9},1)+0)=4,COUNT(SEARCH("~"&MID(A2,{1,2,3,4,5,10},{1,1,1,1,1,999}),"ABCDEFGHIJKLMNOPQRSTUVWXYZ"))=6)

and in A2, use the DV formula as =B2=TRUE