I need to be able to type a character string like  A-  into a cell and have excel average that cell along with other cells that contain letters or numbers. I would have conversions for what number each character string would equal. There is the option of using vlookup but that takes a helper cell for every cell containing a letter and that would take a long time to create since I will end up having nearly 10000 cells that could contain letters. As context the purpose is to convert letter grades to number grades so they can be averaged. Here is an example, say A- equals 95; B+ equals 93; and B equals 90. Now have cell A2 contain B, cell A3 contain A-, cell A4 contain B+. Now have cell B2 have this formula =AVERAGE(A2:A4) I want it to come back with a result of 92.6.

​I need to be able to type a character string like  A-  into a cell and have excel average that cell along with other cells that contain letters or numbers. I would have conversions for what number each character string would equal. There is the option of using vlookup but that takes a helper cell for every cell containing a letter and that would take a long time to create since I will end up having nearly 10000 cells that could contain letters. As context the purpose is to convert letter grades to number grades so they can be averaged. Here is an example, say A- equals 95; B+ equals 93; and B equals 90. Now have cell A2 contain B, cell A3 contain A-, cell A4 contain B+. Now have cell B2 have this formula =AVERAGE(A2:A4) I want it to come back with a result of 92.6.  Read More

​