Hello, I have strings that I need a formula (preferably) or Macro (less preferred) to remove everything after the last instance of a digit/letter combo. I'm not sure I’m explaining this with the right wording so here's some examples.

Red Black Green 1640 YX234U Front Rear
(Removes after YX234U “Front Rear” leaving "Red Black Green 1640 YX234U")

White Yellow 2233F TX645 Front Rear Side
(Removes after TX645 “Front Rear Side” leaving "White Yellow 2233F TX645")

Thank you