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
Bookmarks