Search and Replace using excel? Or other method
-
I need to search and replace multiple text files for multiple text strings. I have around 200 files I need to search throughout to look for about 1600 text strings and replace them with a different text string. I have the text I need to find in column A of an excel file and the text I want to replace it with in column B. i.e., find text in cell A1 and replace with B1, A2 with B2 etc. Is there a way to reference excel and search and replace based on this? If not does anyone know of an other way to do so?
-
Try an Excel and not a Notepad++ forum?