Hello,
I have a task to send mail to the person responsible based on the dept code with the part number.
Each alphabet has a dept associated.
For example letter "K" is a dept and the contact is example@gmail.com. The critical part is that all the letters are in a single cell. Need help...