# Thread: How to find Average Score where scores are separated by a dash Thanks: 0 Likes: 0

1. ## How to find Average Score where scores are separated by a dash

I have to find average score for each match but because the scores are in same cell I cannot just use average function Any ideas please?

 Match 1 Match 2 Match 3 Match 4 Match 5 Match 6 Match 7 Match 8 Match 9 Match 10 1 - 2 1 - 1 2 - 0 1 - 0 2 - 2 1 - 1 2 - 1 1 - 2 3 - 0 1 - 1 1 - 1 2 - 1 2 - 0 2 - 1 1 - 1 2 - 2 2 - 1 2 - 1 3 - 0 1 - 1 1 - 1 1 - 1 3 - 1 2 - 0 1 - 1 1 - 2 2 - 1 2 - 1 2 - 0 2 - 1 0 - 3 1 - 3 3 - 0 2 - 1 1 - 1 0 - 2 2 - 0 0 - 1 3 - 0 2 - 1 0 - 2 1 - 0 2 - 1 2 - 1 1 - 1 2 - 1 1 - 1 1 - 2 3 - 0 1 - 1 0 - 2 1 - 1 2 - 0 2 - 1 0 - 0 1 - 1 2 - 1 0 - 1 2 - 0 1 - 1 0 - 2 1 - 1 3 - 1 1 - 2 0 - 1 0 - 2 2 - 2 1 - 1 4 - 1 0 - 2 0 - 3 2 - 1 2 - 0 2 - 1 1 - 1 1 - 1 2 - 0 0 - 1 3 - 0 1 - 2 1 - 3 1 - 1 3 - 0 2 - 1 1 - 1 2 - 0 3 - 1 0 - 2 3 - 0 2 - 2 0 - 2 2 - 2 3 - 0 2 - 1 1 - 1 1 - 2 2 - 0 1 - 2 3 - 0 1 - 1 1 - 3 1 - 1 2 - 0 2 - 2 2 - 1 1 - 1 3 - 1 1 - 1 4 - 0 0 - 0 1 - 1 1 - 1 3 - 0 2 - 0 2 - 1 2 - 1 2 - 0 1 - 2 4 - 0 1 - 2 0 - 2 1 - 1 3 - 1 1 - 1 0 - 1 2 - 2 2 - 0 0 - 1 4 - 0 1 - 1 1 - 3 1 - 1 2 - 1 1 - 1 1 - 2 1 - 2 2 - 1 1 - 1 3 - 1 1 - 1 0 - 3 2 - 1 3 - 0 1 - 0 1 - 2 1 - 2 2 - 0 1 - 0 4 - 0 1 - 1 0 - 2 2 - 2 2 - 0 1 - 1 2 - 0 1 - 1 2 - 1 0 - 1 3 - 1 2 - 2 0 - 2 1 - 2 2 - 0 3 - 1 0 - 2 1 - 1 1 - 1 1 - 1 2 - 0 0 - 0 3 - 0 1 - 2 2 - 0 1 - 0 1 - 1 1 - 2 2 - 0 0 - 1 2 - 0 1 - 1 0 - 3 1 - 1 2 - 0 0 - 1 1 - 1 1 - 2 2 - 0 0 - 2 3 - 0 1 - 1

Regards
Johnbe

2. ## Re: How to find Average Score where scores are separated by a dash

Separate the scores using Text-to-Columns. Cant see any other way.

3. ## Re: How to find Average Score where scores are separated by a dash

Maybe
=AVERAGE(LEFT(A2,1),RIGHT(A2,1))