For ex:
98ABCD8 returns true
98XYZ99 returns true
88DG987 returns false
Help me here, please. Needs a formula rather than a VBA code. Thank you
For ex:
98ABCD8 returns true
98XYZ99 returns true
88DG987 returns false
Help me here, please. Needs a formula rather than a VBA code. Thank you
How representative is that of your actual data? It looks from that sample as though you can start at the third character, then find the first number after that, and see if there are at least 3 characters in between, rather than having to look for a sequence of at least 3 amongst many possible sequences.
Don’t have an account yet? Register yourself now and be a part of our community!