for example >LLLL-99-99-99-LLL9999-LL## where L is ALPHA, 9 numeric, # can be either.
example of cell passing this mask; "ABCD-10-20-45-ABC1234-AB00"
a function would be best the have a column to flag the data column good/bad and perhaps where "bad"
thanks for any guidance,
Greg
example of cell passing this mask; "ABCD-10-20-45-ABC1234-AB00"
a function would be best the have a column to flag the data column good/bad and perhaps where "bad"
thanks for any guidance,
Greg
SAMPLE.xlsx | ||||
---|---|---|---|---|
A | B | |||
1 | DATA | GOOD/BAD | ||
2 | ABCD-10-20-45-ABC1234-AB00 | G | ||
3 | ABCD-10-20-45-ABC1234-AB01 | G | ||
4 | ABCD-10-20-45-ABC12B4-AB02 | B | ||
5 | ABCD-10-20-45-ABC1234-A123 | B | ||
6 | ABCD-10-20-45-ABC1234-AB04 | G | ||
7 | ABCD-10-20-45-ABC1234-AB05 | G | ||
8 | ABCD-10-20-45-ABC1234-1234 | B | ||
9 | ABCD-10-20-45-ABC1234-AB07 | G | ||
Sheet1 |