Hello,
I am working with a large set (>25000) of text cells ; I need to identify those where the numbers in them conform to a particular pattern.
Some of the text cells' content:

A2NGO3LA1RE3
A2NGO3LA1TA3
A2NGO3LA1TO3
A3NGO2LA3ZZJO1NE3
A6NGO3LI3

I need to identify two patterns: In the first pattern, the third NUMBER from the right (3 in the first example above) is a 1, and the first and the second number from the right is either a 2 or a 3 (none of the above conform to this pattern). In the second pattern, the second number, again from the right, is a 1 and the first and third number from the right a 2 or 3 (the first four in the set above conform to this pattern).
Note that not all cells even have three numbers in them and that the distance between the numbers (i.e. the amount of other characters in between) may vary. All numbers are single-digit only.
Any help would be greatly appreciated!
Many thanks