=IF(ISERR(FIND(" ",$A2)),IF(ISERR(FIND(" ",$A2)),999,FIND(" ",$A2)),FIND(" ",$A2))
=IF(ISERR(FIND(" ",RC1)),IF(ISERR(FIND(" ",RC1)),999,FIND(" ",RC1)),FIND(" ",RC1))
=LEFT($A2,$D2-1)
=LEFT(RC1,RC4-1)
=RIGHT($A2,LEN($A2)-$D2)
=RIGHT(RC1,LEN(RC1)-RC4)
=MID($A2,$D2+1,999)
=MID(RC1,RC4+1,999)
=IFERROR(FIND(" ",$A2),IFERROR(FIND(" ",$A2),999))
=IFERROR(FIND(" ",RC1),IFERROR(FIND(" ",RC1),999))
=IFERROR(TEXTBEFORE($A3,{" "," "}),$A3)
=IFERROR(TEXTBEFORE(RC1,{" "," "}),RC1)
=IFERROR(TEXTAFTER($A3,{" "," "}),$A3)
=IFERROR(TEXTAFTER(RC1,{" "," "}),RC1)