I have data that includes area codes. I am trying to figure out some way to convert the area code into the state that corresponds. For instance 703 = Virginia. I am trying to avoid looking up every area code to compile a database. Is there one available somewhere? Is there a VBA code that I can use to search for it online and input the value?
Bookmarks