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}),"ABCDEFG HIJKLMNOPQRSTUVWXYZ"))=6)
and in A2, use the DV formula as =B2=TRUE
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}),"ABCDEFG HIJKLMNOPQRSTUVWXYZ"))=6)
and in A2, use the DV formula as =B2=TRUE
Cheers !
Excel Range to BBCode Table
Use Social Networking Tools If You Like the Answers !
Message to Cross Posters
@ Home - Office 2010/2013/2016 on Win 10 (64 bit); @ Work - Office 2016 on Win 10 (64 bit)
Posting Permissions
Reply With Quote
Bookmarks