Hi,
I've a list of item paths, each with a product code in them. The product code is always in the format AAA1111, but it's in a different place in each string, and each string is a differing length.
Can anyone think of a forumla that will extract that 7 character code? I have 6,500 lines so...