How to check and batch replace text within a formula in an Excel spreadsheet possibly hundreds of files
Posted on 2016-11-10
thousands of excel files that use a VLOOKUP command to get data from another spreadsheet. a problem caused some of them to change their formulas i have figured out what the incorrect strings are and can do a find/replace in each formula but cant manually do that for each one.
additionally, some files are fine, some have "problem 1" text and some have "problem 2" text to be replaced .
any ideas for an automated way to do this?