Each archive container ID starts with a two-letter region, then a hyphen. Put the region in a helper column for grouping.
Keep the full identifier and read two characters
Enter NW-014, SE-209, and NE-087 in A2:A4. In B2 use =LEFT(A2,2) and fill down. The region results should be NW, SE, and NE. Keep the original strings and their zeroes in column A.

Illustrated fixed-width prefix. Keep the original codes as text.
Check whether the expected delimiter is present
If the input may be malformed, try =IF(MID(A2,3,1)="-",LEFT(A2,2),"Check code"). N-014 fails this check because its third character is 0. A delimiter check covers only the position. Compare the extracted prefixes against the approved list and inspect other parts of the code if they matter.

Illustrated format check. Review approved prefixes and numeric lengths separately.



