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