Hi all,
Please suggest an excel formula to create password to open IT intimations. We have a list of client's PANs and their dates of Birth in excel. Each time we have to open ITR Vs or Intimations we have to manually type PAN in lower case and Date of birth in ddmmyyyy format. It takes up a lot of time.
So, it there is formula in excel which converts this information (PAN and DOB) into password?
eg PAN :ANOPS1987K
DOB: 26/03/1980
Passsword: anops1987k26031980
Hi
Put PAN in cell A2, DOB in cell B2 & follo. formula in C3.
=lower(A2)&text(B2,ddmmyyyy)
Thanks!!
@ VaibhavJ
Dear Mr. Vaibhav, I tried the formula given by you, but error was being shown. However, the following formula is working:
.
PAN in A1, D.O.B in B1 and Formula in C1
.
=LOWER(CONCATENATE(A1,TEXT(B1,"DDMMYYYY")))
| Originally posted by : |)eep @ k Gupt/\ | ||
 |
Dear Mr. Vaibhav, I tried the formula given by you, but error was being shown. However, the following formula is working: . PAN in A1, D.O.B in B1 and Formula in C1 . =LOWER(CONCATENATE(A1,TEXT(B1,"DDMMYYYY"))) |
 |
it should be: =LOWER(A2)&""&TEXT(B2,"ddmmyyyy")
| Originally posted by : @ VaibhavJ | ||
|
Originally posted by : |)eep @ k Gupt/\ Dear Mr. Vaibhav, I tried the formula given by you, but error was being shown. However, the following formula is working: PAN in A1, D.O.B in B1 and Formula in C1 =LOWER(CONCATENATE(A1,TEXT(B1,"DDMMYYYY"))) . it should be: =LOWER(A2)&""&TEXT(B2,"ddmmyyyy") |
|
Both are working.
If you want to do on click of 2 button then use this maco file:
Open file, enable macro if you are prompted, Enter file path & file name along with DOB & PAN in Col C & D.
Clcik on button & when prompted click on PAN no. for which you want pdf to open & press ok and in 5 sec. fille will get opened.
Thanks!!
@ VaibhavJ
In date format, I am not able remove slashes..in both the given formulas
But sir how to put in dial button
Shriraj @ use insert shape from file menu and assign macro
CAclubindia
