Hello,

Is there a way to create a drop-down list that does the following:

When the user opens the drop-down, you see (for example) AK-Alaska, AL-Alabama, AR-Arkansas, etc. But when the cell is populated, it only returns the two-character state.

Your health is greatly appreciated.
TIA, Karen