View Single Post
 
Old 05-12-2019, 02:56 PM
14spar15 14spar15 is offline Windows 7 64bit Office 2010 64bit
Advanced Beginner
 
Join Date: Mar 2011
Posts: 41
14spar15 is on a distinguished road
Default Remove everything after the last instance of a digit/letter combo

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
Reply With Quote