Hi,

I am working with a bunch of excel files and want to modify all instances of a string, say, 'abcdefg' with another string, say, 'xyz123'.

I need to replace the former string in the whole excel file, wherever it is - in cell values, formulae, cell comments, File level information (File --> Properties) or anywhere else that is possible.

I replaced in all above instances and when I use windows explorer search to make sure there is no instance of the string abcdefg left in the file, I find that the explorer search still identifies this file, when I search with 'A word or phrase in the file' option.

Also, when I open the excel file in any of the text editors (like Notepad), I see the string abcdefg but when I 'search' for it by opening the file in excel, it says the string is not present.

Can anyone think of where else could an excel file be saving text data other than these?

Also, if the excel file is based on some standard template, then will the file have some content related to the template in some 'hidden' way?

Thanks in advance
SBRS