Find Text String From Last Space in Excel/Google Sheets

=TRIM(LEFT(SUBSTITUTE(A2," ",REPT(" ",LEN(A2))),LEN(A2)))