Checking the right sequence of records

Hi there!

I have a list of records in excel which indicates certain codes. For example:

N1P5Q9L2K1K6K7F2K4G6F4I2H4


Now I am working on the excel formula that can check for me if the following sequence is correct, which is letter/number/letter/number etc

The result I need would be TRUE if it was correct or FALSE if for example there were two numbers standing next to each other or two letters in fact.

I would be grateful for any solutions.

Cheers.
Dawid

Try this ...

=ISNUMBER(SUMPRODUCT(MID(A1&1,ROW(INDIRECT("1:"&ROUNDUP(LEN(A1)/2,0)))*2,1)
/ISERR(--MID(A1,ROW(INDIRECT("1:"&ROUNDUP(LEN(A1)/2,0)))*2-1,1))))

My contribution

=IF(ISNUMBER(A1)/LEN(SUMPRODUCT(MID(0&A1,LARGE(INDEX(ISNUMBER(--MID(A1,ROW($1:$60),1))*ROW($1:$60),0),ROW($1:$60))+1,1)*10^ROW($1:$60)/10))=2,"TRUE","FALSE")


Décio

Thank you all for your answers. But honestly I am struggling to understand your concepts of those formulas but have no idea how to read it.

Could you explain it from scratch, which function did you start from in order to make th whole formula?
Then I might catch how to read it.

Thank you in advance.

Szwadron6

I like to get only numbers of the text so in the example I found 13 characters, there taking total number of characters dividing by number of characters numbers the results if true is 2, if acrontaire is false

I'm using Google translator because English is not my native language.

Décio of Brazil