I have an entire column of entries.

Example:
1CN
1DBAN
1MA1
1MA2
1CSZ
2CN
2DBAN
2MA1
2MA2
2CSZ
3CN
3DBAN
3MA1
3MA2
3CSZ