Hello,

May I ask how to "loop" through a string using formula (NOT VBA) and on the 1st instance that the criteria is met (in this case a non-numeric), give me the output.

e.g1 the string is: 05abcd123456789xyz000

Since I know that the 1st 2 strings will always be numbers, follow by 4 letters, I want to check from the 7th string onwards, "loop" through the remaining string and once it is not a number, stop and return from the 1st string. In the above example, the ANSWER will be 05abcd123456789