Thanks for your solutions guys.
Managed to get what was required using the below for anyone who happens to be in a similar situation:
B2:
=TRIM(LEFT($A$2,FIND(" ",$A$2,1)-0))
C2:
=TRIM(RIGHT(LEFT($A$2,FIND(" ",$A$2,FIND(" ",$A$2,1)+1)),FIND(" ",$A$2,FIND(" ",$A$2,1)+1)-FIND(" ",$A$2,1)))
D2:
=TRIM(RIGHT(LEFT($A$2,FIND(" ",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,1)+1)+1)),FIND(" ",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,1)+1)+1)-FIND(" ",$A$2,FIND(" ",$A$2,1)+1)))
E2:
=TRIM(RIGHT(LEFT($A$2,FIND(" ",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,1)+1)+1)+1)),FIND(" ",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,1)+1)+1)+1)-FIND(" ",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,1)+1)+1)))
F2:
=TRIM(RIGHT(LEFT($A$2,FIND(" ",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,1)+1)+1)+1)+1)),FIND(" ",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,1)+1)+1)+1)+1)-FIND(" ",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,1)+1)+1)+1)))
G2:
=TRIM(RIGHT(LEFT($A$2,FIND(")",$A$2,FIND("(",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,1)+1)+1)+1)+1)+1)+1)-1),FIND(")",$A$2,FIND("(",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,1)+1)+1)+1)+1)+1)+1)-FIND("(",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,1)+1)+1)+1)+1)+1)-1))
H2
=TRIM(RIGHT(LEFT($A$2,FIND(" ",$A$2,FIND(" ",$A$2,FIND(")",$A$2,FIND("(",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,1)+1)+1)+1)+1)+1)+1)+1)+1)),FIND(" ",$A$2,FIND(" ",$A$2,FIND(")",$A$2,FIND("(",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,1)+1)+1)+1)+1)+1)+1)+1)+1)-FIND(" ",$A$2,FIND(")",$A$2,FIND("(",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,1)+1)+1)+1)+1)+1)+1)+1)))
I2
=TRIM(RIGHT(LEFT($A$2,FIND(" ",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,FIND(")",$A$2,FIND("(",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,1)+1)+1)+1)+1)+1)+1)+1)+1)+1)),FIND(" ",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,FIND(")",$A$2,FIND("(",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,1)+1)+1)+1)+1)+1)+1)+1)+1)+1)-FIND(" ",$A$2,FIND(" ",$A$2,FIND(")",$A$2,FIND("(",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,1)+1)+1)+1)+1)+1)+1)+1)+1)))
J2
=TRIM(RIGHT(LEFT($A$2,FIND(" ",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,FIND(")",$A$2,FIND("(",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,1)+1)+1)+1)+1)+1)+1)+1)+1)+1)+1)),FIND(" ",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,FIND(")",$A$2,FIND("(",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,1)+1)+1)+1)+1)+1)+1)+1)+1)+1)+1)-FIND(" ",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,FIND(")",$A$2,FIND("(",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,1)+1)+1)+1)+1)+1)+1)+1)+1)+1)))
K2
=TRIM(RIGHT(LEFT($A$2,FIND("(",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,FIND(")",$A$2,FIND("(",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,1)+1)+1)+1)+1)+1)+1)+1)+1)+1)+1)+1)-1),FIND("(",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,FIND(")",$A$2,FIND("(",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,1)+1)+1)+1)+1)+1)+1)+1)+1)+1)+1)+1)-FIND(" ",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,FIND(")",$A$2,FIND("(",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,1)+1)+1)+1)+1)+1)+1)+1)+1)+1)+1)))
L2
=TRIM(RIGHT(LEFT($A$2,FIND(")",$A$2,FIND("(",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,FIND(")",$A$2,FIND("(",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,1)+1)+1)+1)+1)+1)+1)+1)+1)+1)+1)+1)+1)-1),FIND(")",$A$2,FIND("(",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,FIND(")",$A$2,FIND("(",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,1)+1)+1)+1)+1)+1)+1)+1)+1)+1)+1)+1)+1)-FIND("(",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,FIND(")",$A$2,FIND("(",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,1)+1)+1)+1)+1)+1)+1)+1)+1)+1)+1)+1)-1))
M2
=TRIM(RIGHT(LEFT($A$2,FIND(" ",$A$2,FIND(" ",$A$2,FIND(")",$A$2,FIND("(",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,FIND(")",$A$2,FIND("(",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,1)+1)+1)+1)+1)+1)+1)+1)+1)+1)+1)+1)+1)+1)+1)),FIND(" ",$A$2,FIND(" ",$A$2,FIND(")",$A$2,FIND("(",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,FIND(")",$A$2,FIND("(",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,1)+1)+1)+1)+1)+1)+1)+1)+1)+1)+1)+1)+1)+1)+1)-FIND(" ",$A$2,FIND(")",$A$2,FIND("(",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,FIND(")",$A$2,FIND("(",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,1)+1)+1)+1)+1)+1)+1)+1)+1)+1)+1)+1)+1)+1)))
N2
=TRIM(RIGHT(LEFT($A$2,FIND(" ",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,FIND(")",$A$2,FIND("(",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,FIND(")",$A$2,FIND("(",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,1)+1)+1)+1)+1)+1)+1)+1)+1)+1)+1)+1)+1)+1)+1)+1)),FIND(" ",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,FIND(")",$A$2,FIND("(",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,FIND(")",$A$2,FIND("(",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,1)+1)+1)+1)+1)+1)+1)+1)+1)+1)+1)+1)+1)+1)+1)+1)-FIND(" ",$A$2,FIND(" ",$A$2,FIND(")",$A$2,FIND("(",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,FIND(")",$A$2,FIND("(",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,1)+1)+1)+1)+1)+1)+1)+1)+1)+1)+1)+1)+1)+1)+1)))
O2
=TRIM(RIGHT(A2,LEN(A2)-FIND(" ",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,FIND(")",$A$2,FIND("(",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,FIND(")",$A$2,FIND("(",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,FIND(" ",$A$2,1)+1)+1)+1)+1)+1)+1)+1)+1)+1)+1)+1)+1)+1)+1)+1)))