Combine LEFT and TRIM Functions

[KINGOFCHAOS17]

Good Evening. I'm trying to combine two functions into one if possible. The first formula uses the LEFT function to strip out the last 5 characters in the string: =LEFT(A2,LEN(A2)-5) I then use the TRIM function =TRIM(B2) to clear out the extra spaces/padding that the system inserts. Example of the data is attached and how I'm currently using the functions is attached.