Excel duplicate hostnames mixed FQDN

I have several thousand hostnames in a list. Some of these names are FQDN, and some are hostname only. How can I identify duplicates in this situation?

HostABC HostABC.domain.com

These are the same host, just one is fully qualified and one is not.