Excel 2010

Thank you in advance, maybe this action is not that difficult for savvy users.

I have a column containing the regular state abbreviations in a CSV document. I would like to create a formula to convert individual cells containing these abbreviations into grouped geographical regions for sales territories. Crudely thinking, run the formula on Col A and populate the result in Col B.

COL A COL B
CA PACIFIC
OR PACIFIC
WA PACIFIC
FL SOUTHEAST
AL SOUTHEAST
NY NORTHEAST