Column A has a pull-down menu with each cell that has various "Zones" to choose from. Column C has cells where numbers are entered. If for example, "Zone 1" is selected in A:2, is there a way to add the letters "TP" or "CD" to the beginning of the number in C:2 after it is typed based on what selection has been chosen in A:2?