hi guys

in cell c2 i have the following data - 6 ran TIME 4m 15.10s (slow by 34.10s) Total SP 115%

in cell d2 i would like the number before ran - in this case 6

in cell e2 i would like the time after TIME - in this case 4m 15.10s

appreciate any help in advance