I need help creating a student test answer report. I want the student's
correct answer returned with a * and their wrong answers returned from the
contents of the excel adress not the adress (their wrong answer should be
diplayed). Thank you for your time and help. Susan

KEY STUDENT I got this far.
B B =IF(ISNUMBER(FIND("B",B2)),"*", "B2")
C D =IF(ISNUMBER(FIND("C",B3)),"*", "B3")
D D =IF(ISNUMBER(FIND("D",B4)),"*", "B4")
D D =IF(ISNUMBER(FIND("D",B5)),"*", "B5")
B A =IF(ISNUMBER(FIND("B",B6)),"*", "B6")
C C =IF(ISNUMBER(FIND("D",B7)),"*", "B7")
E A =IF(ISNUMBER(FIND("E",B8)),"*", "B8")