Combine LEFT and TRIM Functions

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.

Try Cell B2 formula , Drag down

Formula:

Please Login or Register  to view this content.

How about

Formula:

Please Login or Register  to view this content.

Perfect, thank you!

Glad to help & thanks for the feedback.

@KINGOFCHAOS17 You're Welcome. Glad to help . Thank You for the feedback.