Live Course on Drafting of Appeal and Reply of Penalty Notice by CA Sachin Sinha. Register Now!!

Excel formula

(Guest)

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

Reply
Follow
Share

11 Replies

@VaibhavJ (Believe!! Live your dreams!) (33511 Points)
Replied 11 February 2015

Put PAN in cell A2, DOB in cell B2 & follo. formula in C3.

=lower(A2)&text(B2,ddmmyyyy)

Thanks!!
@ VaibhavJ

2 Like

Deepak Gupta (CA Student) (15922 Points)
Replied 11 February 2015

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")))

2 Like

@VaibhavJ (Believe!! Live your dreams!) (33511 Points)
Replied 11 February 2015

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")

Deepak Gupta (CA Student) (15922 Points)
Replied 11 February 2015

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.

sunny (TAXATION) (50 Points)
Replied 11 February 2015

Open the pdf file in adobe acrobat professional version n in security option select remove security. The next time u open the file, it will open without password

1 Like

(Guest)

Thanks for the help. Its really easy now :)

1 Like

BILAL CHAUHAN (Chief Finance Officer) (64 Points)
Replied 12 February 2015

If you dont have a professional version of acrobat, alternatively you can print the file to a virtual PDF printer like doPDF. The newly created PDF file will have no password.