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

[johnbe]

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

<colgroup><col span="10"></colgroup><tbody>
</tbody>

Regards
Johnbe

 

[cunningAce]

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

 

[Fluff]

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