Hi,
I've got a load of tennis data in the below format and I'm trying to calculate how many games each player won (excluding the numbers in brackets). Does anyone have a quick/clever way of isolating the games before the hyphens in one column and the numbers after the columns so I can do to this? Any help much appreciated. If I do text to columns to split on the "-" Excel turns everything into dates.
Thanks
Sid
7-6(6) 6-2 7-6(3)
6-3 6-1 6-1
6-2 6-3 6-3
6-4 6-4 6-4
6-1 6-2 6-4
6-2 6-3 6-2
7-6(7) 4-6 6-2 6-3
6-1 2-6 6-4 6-2
3-6 7-6(3) 6-3 7-5
5-7 6-3 6-0 7-5
6-1 3-6 5-7 6-4 6-1
6-3 6-3 4-6 2-6 6-3
7-5 6-1 7-6(5)
6-2 7-6(8) 6-0
2-6 6-7(1) 7-5 6-2 6-2
7-5 6-4 6-2
6-4 6-3 7-6(3)
6-4 3-6 6-0 7-5
6-2 6-2 7-6(2)
7-5 6-2 6-3
7-6(5) 4-6 6-2 6-2
7-5 6-3 6-3
6-3 6-4 6-4
6-2 6-3 6-2
6-3 3-6 2-6 6-3 6-4
7-5 7-6(4) 4-6 6-0
Bookmarks