Is there a way to change what is entered into a cell from a drop down list..
Basiclly what I want to do is when the user selects a state from the drop
down list lets say from column a1 I want instead of the state name to fill in
the cell, I want the state abbreviation to fill the cell again, based off the
users selection from the drop down list. I created the drop down list useing
the Data Validation tool. I thought of using an If statement however that
would be monsterous due to there of course being 50 states. Any assistance
would be greatly appreciated.

Thank you