79188421

Date: 2024-11-14 10:53:59
Score: 0.5
Natty:
Report link

Using BYCOL() and TEXTSPLI0T() (and AND()):

=BYCOL(TEXTSPLIT(A7,","),
LAMBDA(a,    
AND(
ISNUMBER(VALUE(CONCAT((FIND(MID(a,1,1),"ABCDEFGHIJKLMNOPQRSTUVWXYZ")),(FIND(MID(a,2,1),"ABCDEFGHIJKLMNOPQRSTUVWXYZ"))))),
ISNUMBER(VALUE(MID(a,3,8))),
LEN(a)=10)))

This will output an array, if you wrap an AND() around it, it will output just TRUE or FALSE.

Edition 1

Note, I TEXTJOIN()-ed the list from A1:A5 in cell A7, with ", ".

Edition 2

Sample 2 to show FALSE output.

(Excel in different language, WAAR = TRUE, ONWAAR = FALSE)

Also note: this doesn't exclude duplicates: Duplicates

Cell highlight manually done

Reasons:
  • Probably link only (1):
  • Long answer (-0.5):
  • Has code block (-0.5):
  • Low reputation (0.5):
Posted by: Excellor