Excel formula

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.

Thanks for the help. Its really easy now :)

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