In one cell, I have a string that looks like A_B_C, where A, B and C are strings. The string that makes up C can be one of 10 different strings. I would like to do some soft of comparison of what C is and then depending on its value, append a different string to the end of a different cell. Let me include an example. Suppose C=aa so that the total string in the cell would look like A_B_aa. In my next cell, since the first cell ends in "aa", I would like the next cell to end in "_endsinaa". I guess I would need to create a table somewhere matching the possible values of C with what text I would like to put in the next cell. I am not sure how to do something like this. I am also not an expert by any means. Any help is greatly appreciated.