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

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. regards, Jafer

hey plz retype agn all 10 char in cell..

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

Thanks!!

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

Originally posted by : Gurupal Singh
	Showing  #Name? .........  i have enabled MACRO .. still getting errors

Hey make sure you have spelled ispanvalid correctly.

Thanks!!

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

Hi,

you can know about macro from following URL:

https://www.wikihow.com/Write-a-Simple-Macro-in-Microsoft-Excel

https://www.howtogeek.com/162975/geek-school-learn-how-to-use-excel-macros-to-automate-tedious-tasks/

Thanks

 gud 1 vaibhav

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

Plz expln

Regards

Sandeep jain

@ Sandeep try this attached file!

Thanks//Vaibhav

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.

Hi,

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.

Cheers!
Team Legistify

Contact : +919250004782/+919250004781 Or

Visit : www.legistify.com/#

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.

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

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

There are some errors i guess.

PLEASE SHARE ME FORMULA ON SRIKANTHLAL @ HOTMAIL.COM