I currently have a large worksheet with over 7,000 cells. I have listed regions under a column i named "Location." In that column I want to change the region from lets say "Eastern North Central" to "US-Midwest," "Mountain" to "US-West" and so on. Is there anyway I could use a function to enter under my location column so all regions change to my desired classifications so i don't have to manually change over 7,000 cells? Perhaps some convoluted IF function?
Solved by Z. J. in 11 mins