So I have two text strings, in seperate lengths, I want my formula to be able to pick up the CH12 or GB01 and copy it to a different cell.
I am tring to get it to go through a Vlookup as there are a lot of company codes. Ideally what I would like it to do is to look at the text string finds the...