Leith,

Thanks so much for the help. The reason that D, E, and F looks strange is because I need the file to look for the wording, and then replace it with new wording. For instance, the submitted file may say "E5103 Follow-Up 3". Currently, I am tasked with erasing the E5103 so that it only reads Follow-Up 3. I have to do this for multiple spreadsheets, so the E5103 may read E1111, E2222, E3333, etc. The same goes for A, B, and C. My hope was that coding could be written so that if it sees specific text in those fields, then it will replace the cell with the text I identified in the posted above. Does that make sense?

Thanks,

csch123