Excel formula


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