While working on a KnowledgeLake project on MOSS 2007, I had to create a site column for state. They wanted it to be a drop-down box with state abbreviation and name. I had two choices:
- Manually type in all fifty states with abbreviations.
- Find a list on the internet.
Of course, I chose the second. I could not find a list that met my requirements: State Abbreviation-State Name. An example would be: AK-Alaska. Enter the & function in Excel, which combines the contents of several Excel cells into one. I found a list on the internet of two columns, abbreviations, and states. I then used the & function as described here to combine them. Then I pasted the result into my SharePoint site column box, and voila!
