I have a list of addresses throughout the United States that I would like to separate into regions. I.E. southwest, northeast, southeast, etc. based on the state. How can I do this?

P.S. As a side note, I also need to know how to mark a thread as solved.

Thank you for your help!