When the number of possible variants of beginnings of end part of strings is not more than 6 (seventh IFERROR() is reserved for no ending found), then like this:
Code:
=IFERROR(LEFT($A2,IFERROR(SEARCH(" Front",$A2),IFERROR(SEARCH(" Top",$A2),IFERROR(SEARCH(" Rear",$A2),IFERROR(SEARCH(" Bottom",$A2),0))))-1),$A2)
When there is more possible starts for ending part, then you have to croup IFERROR()'s using IF(). But the formula will be terrible - probably you have to use several helper columns to keep some overview how the calculation is done and which condition is where applied.