Extract PAN from GST number: Friends in this article we will learn how to extract PAN from GSTIN (Goods and Service Tax Identification Number). so let’s get started because if you don’t start you will always only be stuck in your thoughts.

With the help of excel we can eaisly extract PAN from the goods and service tax number.

So let’s first understand the Goods and Service Tax Identification Number (GSTIN):

GSTIN consists of 15 digits: 27AAAAP0267H2ZN

State Code		PAN										Entity Code	Z by default	Check Digit
1	2	3	4	5	6	7	8	9	10	11	12	13	14	15

27: first 2 digit- State Code

AAAAP0267H: Next 10 digit- PAN

2: 13th digit – entity code/number
Z: 14th digit-“Z” by default

1: 15th digit- Check digit

Extract PAN from GSTIN

Now let’s learn in Excel to extract PAN from the GST number to do that lets take above GST number

27AAAAP0267H2ZN

now in the next cell type = MID(reference of cell contain gst number like A2,2,10) now you will get PAN from GST number.

Now let’s do with us with the help of live video from youtube https://www.youtube.com/c/edutaxtuber

In this way, you can easily extract PAN from GSTIN. If you are facing any problems in Excel don’t forget to comment below, we will reply to your query as soon as possible.

If you want to learn more about Excel you can visit the https://edutaxtuber.in/excel-tutorial/.

HRA Exemption Calculator

Basic Salary HRA Received Rent Paid