A customer sent a list of parts he wants quoted. The problem is the list he sent has the part number(which is what I need to do the lookup) in the middle of the cell. The general format of the cells are "blah blah blah description 8366379 COMPANY NAME." I need only the 8366379. The problem is that there are a lot of variations to that format. Sometimes the part number is 5 characters long, other times its 10. Sometimes the part number starts with a letter instead of a number. The length of the description is also always changing.
The only constant is that the part number is the 3rd to last word in the description. Is there a way to pull only the 3rd to last phrase out even though the length of that word and where it starts in the string often changes?
Thanks for any help
Edit: I've added a sample file
Bookmarks