Well, you're going to need a lookup table of some sort to translate the first letter/3 digits into the plant locations as you want to see them. Could you attach such a table or at least go through how the information in column B is used to determine location.