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
Bookmarks