Average Excel Grades with Numbers and Letters in the Same Cell
Question details
Calculate an average from grades that contain a number and a letter in the same cell while keeping the original grades visible.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- A grade range contains entries such as 80 B and 75 C, and the user wants to average the numeric scores.
- Observed behavior
- The desired result is an average of the numeric portions without removing the letter grades from the original cells.
Check that each grade starts with a number followed by a space and its letter, such as 80 B, with no leading spaces. The examples below use grades in A2:F2 and empty helper cells in G2:L2.
Average the numeric grades using helper cells
Extract each numeric score into a helper cell, then average the extracted values while leaving the original grades unchanged.
In G2, enter =IF(A2="","",IFERROR(VALUE(LEFT(A2,FIND(" ",A2&" ")-1)),"")) and press Enter.
Select G2 and drag its fill handle across to L2. Each helper cell extracts the number from the corresponding cell in A2:F2.
In M2, enter =IFERROR(AVERAGE(G2:L2),"") and press Enter. The result is blank when no numeric scores are available.

Average mixed number and letter grades in WPS Spreadsheets
Use helper cells in WPS Spreadsheets to extract numeric scores and average them without changing the original grade entries.
- 1. Open the grade sheet: Open your workbook in WPS Spreadsheets and check that the grades are in A2:F2, with G2:M2 available.
- 2. Extract the first number: In G2, enter =IF(A2="","",IFERROR(VALUE(LEFT(A2,FIND(" ",A2&" ")-1)),"")) and press Enter.
- 3. Copy the formula: Drag the fill handle from G2 across to L2 to extract each numeric score.
- 4. Average the scores: In M2, enter =IFERROR(AVERAGE(G2:L2),"") to display the average or a blank if there are no numeric scores.

Frequently Asked Questions
Will the formula work with a grade such as 90 A+?
Yes. The helper formula extracts the number before the first space, so 90 A+ produces 90. Keep a space between the number and the letter grade.
What happens if a grade cell is blank?
Its helper cell returns an empty string, which AVERAGE ignores. If all helper cells have no numeric scores, the IFERROR formula in M2 displays a blank.
How can I display zero instead of a blank when there are no scores?
In M2, use =IFERROR(AVERAGE(G2:L2),0). This returns 0 if AVERAGE has no numeric scores to calculate.
Does the numeric average give me a GPA?
Not necessarily. A GPA usually uses grade points rather than raw numeric scores. Apply your school’s conversion and weighting rules before calculating it.




