Sorting number combinations
=AND(LEN(A1)=13,ISNUMBER(--LEFT(A1,6)),ISNUMBER(--RIGHT(A1,6)),AND(UPPER(MID(A1,7,1))="A",UPPER(MID (A1,7,1)<="Z")))
will return TRUE or FALSE for compliance with your requirement. Sort or
filter as appropriate.
--
David Biddulph
"STRAC" wrote in message
...
Is there any way to sort numbers in a spreadsheet column that match a
specific criteria (NNNNNNANNNNNN). I have a 8500 record catalog with many
different types of stock numbers (incorrect) that I need to identify in
order
to correct them (13 character, alpha/numeric, with the alpha in the 7th
position).
|