Excel 2010 | ||||||||
---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | |||
1 | Stoke 0-1 Aston Villa | Stoke | 0 | - | 1 | Aston Villa | ||
2 | Stoke City 2-4 Stoke city | Stoke City | 2 | - | 4 | Stoke city | ||
3 | man utd 10-2 Arsenal | man utd | 10 | - | 2 | Arsenal | ||
Sheet1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
B1 | =TRIM(LEFT(A1,FIND("-",A1)-3)) | |
C1 | =MID(A1,FIND("-",A1)-2,2) | |
E1 | =MID(A1,FIND("-",A1)+1,FIND(" ",A1,FIND("-",A1))-FIND("-",A1)-1) | |
F1 | =MID(A1,FIND(" ",A1,FIND("-",A1))+1,99) |