Putting it simpler that data on a and b and c , need formula on d to give results as attached M M B C

AAA AMANDLA DLN m
AAA MANDALA DLN m
AAI BALADIN DLN b
AAE CANALED DLN c