William, Thank you so very much for answering–I sure do appreciate it! I never did get that working, so your answer is extremely helpful. Here is where I am… I can get one line of the code to work, but having the two “IF” statements in the same formu...

This is great, but I am not able to figure out how this works. Where in your formula do I enter the cell/column from which the information is being read (where the complete title currently resides)?