how will i code A= 1, B= 2, C=3 ,D=4 in this excel sheet Q1 Q2 Q3 Q4 Q5 Q6 Q7 1 B A A B A D A 2 C B A B A D A 3 B A A B A D C 4 C B A D A A B 5 C C A B A D C 6 D B A B A D A 7 C B A B A A A 8 C C A D A D B 9 C B A D A A A 10 A B A B A D C 11 C A A B A A B