Hi,

In Word I'd use wildcards to do this. I'm not sure how to do it in Excel.

I need to search a column for the text "Translation of" if that text is found, I need to delete the text and put "with translation" at the end of the string. An added bonus would be if I could have it automatically highlight the cell in Red if it was changed. Here's a sample with before and after tables: Sample.xlsx

Thanks!
Rob