Which word is only a preposition when it can be substituted with the word except otherwise it is a coordinating conjunction?

The Word "but" is a coordinating conjunction when used to contrast different ideas in a sentence. However, when it can be replaced with "except," it functions as a preposition indicating exclusion.