Easy Office
LCI Learning

Excel file to check whether pan no. is valid or not

Page no : 2

@VaibhavJ (Believe!! Live your dreams!)   (33511 Points)
Replied 09 January 2013

Originally posted by : jafer

Hi sir,

It is saying total charactor is 11 but i actually entered 10 digits only. can u exactly tell me where i have to put my pan no.?

thanks in advance.



hey plz retype agn all 10 char in cell..

there will be hidden character because of that you are getting this error!!



Gurupal Singh (Accountant) (33 Points)
Replied 12 July 2013

Showing  #Name? .........  i have enabled MACRO .. still getting errors

@VaibhavJ (Believe!! Live your dreams!)   (33511 Points)
Replied 13 July 2013

Originally posted by : Gurupal Singh

Showing  #Name? .........  i have enabled MACRO .. still getting errors

Hey make sure you have spelled ispanvalid correctly.



Hitesh (Accountant) (25 Points)
Replied 17 September 2013

Vaibhav, How can we use it ?  What are macros ? How to record macros ? What I have to do for that ? I am having Excel 2007. 

My mail id is <ht9026 @ gmail.com>

Please reply .. Thanks

@VaibhavJ (Believe!! Live your dreams!)   (33511 Points)
Replied 17 September 2013

sandeep jain (Finacial Advisor) (34 Points)
Replied 26 October 2013

 gud 1 vaibhav

but i found 1 error for PAN No.- AAGCM5406K, its showing False, but its a Valid Pan no.

Plz expln


Sandeep jain


1 Like

@VaibhavJ (Believe!! Live your dreams!)   (33511 Points)
Replied 26 October 2013

@ Sandeep try this attached file!



Attached File : 112266 1243338 pan validation ver 5 00 rev for all.xls downloaded: 413 times

Mohammad Junaid (2 Points)
Replied 05 January 2017

Its not working. I have enabled the developer option but everytime i put enter on function or run macro. it ask for a seleium driver.

Legistify (33 Points)
Replied 11 January 2017



We would be happy to understand your legal concern in detail and help you out.

At Legisitfy, we want to make legal easy, fast and simple and most of all approachable by making it available to more people than ever before. 

Whether you need to find a lawyer, consult or get a quote you can find it all at Legistify.com. So if you need a lawyer or legal advice we are here:) Visit Legistify.com/consult or you can reach us at +919250004781+91-9250004782.We would be happy to offer you 30 min free legal advice.


If you think Legistify could help any of your friends or family, please share with them too. Let’s make law easy for everyone around. 
For anything legal…Legstify it.

Team Legistify

Contact : +919250004782/+919250004781 Or

Visit : www.legistify.com/#

Anubhav Gupta (Accountant) (33 Points)
Replied 27 January 2017

Dear Friends,

Here I am sharing with you my PAN no verification Excel file. Just enter your PAN in PAN no coloumn in capital letters you get the result. You check 100 PAN at a time.

If any query plz reply to me.

Attached File : 1209276 20170127155548 pan no verifcation.xlsx downloaded: 223 times

Ankit (Article) (22 Points)
Replied 16 February 2017

Its not working in my excel sheet.

Please tell me how can i make that work in my excel sheet as the link which you provided is not opening.

My mail id ankitkragarwal1 @ gmail.com

CA CS Manmath Thakur (CA, CS, M. Com.) (71 Points)
Replied 07 April 2017

Its showing incorrect results !!!!!!!!!!!!!!!!!!!!!!!!

While filling TDS return, its shows Invalid PAN, however this excel shows correct PAN

Don’t treat me wrong for sharing this

Amogh Ambulgekar (Others amogh.a@icai.org)   (522 Points)
Replied 17 July 2018

There are some errors i guess.

Sreekanth Lal B.R (CA) (85 Points)
Replied 20 December 2018


kavya (Article) (2 Points)
Replied 22 July 2019

Can you please tell that what macro has to be created?

Leave a reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Join CCI Pro

Subscribe to the latest topics :

Search Forum: