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|
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
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/.