I would write a query to:
Remove the Alpha character, leaving just the number
Check this against a table of numbers (numbers\ tally tables are SO useful yet woefully underused)
Return all numbers in the tally table not in your imported list of IDs
This would provide what you require - correct?