Indian PAN Number Checks

Formula to find the PAN Criteria (1st 5 digits, 4-8 Digits, Last Digit of PAN) Example If PAN No. is "Oracle PAN no.
1st 5 digits (TEXT)"
AWIPK8054K AWIPK =LEFT(E21,5)
Example "Oracle PAN no.
4th-8th digit
(Numbers)"
AWIPK8664K 8664 =MID(E23,6,4)
Example "Oracle PAN no.
Last digit
(TEXT)"
AWIPK8399K K =RIGHT(E25,1)
Example "Oracle PAN Company
Type"
AWIPK8300K P =MID(E27,4,1)
AWICK8399K C
Formula to find if a PAN relates to Company / Non Company (As per 4th Letter of PAN) Example With above reference Formula^ "Oracle PAN Company
Type
as per Alpha"
P Non-Co =IF(F27="","",IF(F27="C","Co","Non-Co"))
C Co

Hi All,

I need a help in this above PAN Checks, if AWIPK8054K is the PAN No. (Permanent Account number) can we separate only Numbers...
for e.g; AW1PK8054K is mentioned in the cell, I want to take only : 18054, so that I can know that Wrong PAN No. is updated in ERP

This will really help Indian Accountants who use to submit TDS payments to Govt.