三項分別提取 (11849) presented separately

C2=LEFT(B2,FIND(" ",B2)-1)

D2=SUBSTITUTE(LEFT(B2,LOOKUP(1,0/(MID(B2,ROW($1:$99),1)=" "),ROW($1:$99))-1),C2&" ",)

E2=SUBSTITUTE(MID(B2,FIND(D2,B2)+LEN(D2)+1,99),"KG",)