I'm not sure if "general" is the right category for this question. New to this forum - first thread.

I have a spreadsheet that identifies phone calls made from our company each month (approximately 7000 line items). I am able to spread the phone number out to isolate the area code into one column. My task is to identify what state each area code represents and then total the number of calls per state and also the minutes to each state.

My question is this: I have the area code isolated - and I also have an excel grid with the current area codes with state designations (approx. 317 of them).

How can I automate my grid to automatically ID the area code and tag the state designation into a separate column?

Your help is appreciated.