Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 06-21-2023, 06:22 AM
Karen615 Karen615 is offline Drop-down for States Windows 7 64bit Drop-down for States Office 2010 64bit
Competent Performer
Drop-down for States
 
Join Date: Jun 2011
Location: Chicago
Posts: 145
Karen615 is on a distinguished road
Default Drop-down for States

Hello,

Is it possible to set up a drop-down for all 50 states? When the user opens the drop-down they can see (for example) New York-NY, California-CA, etc Then when a state is chosen, only the 2-character state is entered into the cell.

Your help is greatly appreciated.

Thank you,
Karen




Using Excel 365
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Extract States from a String soldat452002 Excel 9 04-26-2018 04:16 AM
Drop down box list based on response to another drop down box Phideaux Excel 16 04-13-2018 03:07 AM
Drop-down for States Drop down lists and pulling data from worksheet based on drop down selection cjoyce73 Excel 5 07-17-2017 07:40 AM
How to import a map from mappoint 13 into PP 13 and then color fill individual states rideninc PowerPoint 0 01-22-2014 03:50 PM
Analysis of states and income levels knownunknown Excel 1 01-22-2011 06:35 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:34 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft