Function Problems

Average Excel Grades with Numbers and Letters in the Same Cell

Steven ParkerSteven Parker Nov 14, 2026 868 views

Question details

Calculate an average from grades that contain a number and a letter in the same cell while keeping the original grades visible.

Average Excel Grades with Numbers and Letters in the Same Cell
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.
Before you start

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.

Solution 1Recommended

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.

1
Extract the first score

In G2, enter =IF(A2="","",IFERROR(VALUE(LEFT(A2,FIND(" ",A2&" ")-1)),"")) and press Enter.

2
Fill across the grade range

Select G2 and drag its fill handle across to L2. Each helper cell extracts the number from the corresponding cell in A2:F2.

3
Calculate the average

In M2, enter =IFERROR(AVERAGE(G2:L2),"") and press Enter. The result is blank when no numeric scores are available.

Average the numeric grades using helper cells
Numeric average versus GPA: This calculates the average numeric score, not a GPA on a grade-point scale. A GPA requires a conversion based on the applicable grading policy.
Calculate grades in WPS Spreadsheets

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. 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. 2. Extract the first number: In G2, enter =IF(A2="","",IFERROR(VALUE(LEFT(A2,FIND(" ",A2&" ")-1)),"")) and press Enter.
  3. 3. Copy the formula: Drag the fill handle from G2 across to L2 to extract each numeric score.
  4. 4. Average the scores: In M2, enter =IFERROR(AVERAGE(G2:L2),"") to display the average or a blank if there are no numeric scores.
Keep letter grades visible alongside the original scoresCalculate the numeric average with familiar spreadsheet formulasOpen and edit Microsoft Excel XLSX and XLS filesUse a familiar spreadsheet interface
microsoft office alternative - wps office

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.