Return true if a cell contains any three or more consecutive letters

  • 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.

    Theory is when you know something, but it doesn’t work. Practice is when something works, but you don’t know why. Programmers combine theory and practice: nothing works and they don’t know why

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!