I did try this on my other PC, by the way, and the same Problem exists. Then open the copy you made and save it - now that file will fail to show up in the Search ! ! You will see both the good files show up as having "174026". The only difference is that I opened the file Sample-Fails.xls and then immediately Saved it, which as I stated earlier, makes it fail all Searches from that point forward.Īlso please try this - using Windows Explorer, copy the good file and then redo the Search. One is named "Sample-Works.xls" - Then do a Windows Search for any number in the file, here is one to try that is in the two files: 174026Īnd it will list "Sample-Works.xls" but it will NOT list "Sample-Fails.xls", even though BOTH FILES ARE IDENTICAL !! I copied the same file twice and then named them.
#Windows explorer search for text in files zip#
This is so perplexing that I have placed 2 zip Sample files on my website for you to Download then the search fails for all numbers in that file. no changes or edits at all, just Open and Save. So strange - yet if I open the file then save it.
![windows explorer search for text in files windows explorer search for text in files](https://www.winhelponline.com/blog/wp-content/uploads/2016/04/daterange1.png)
It all started with some files that were sent to me - they work PERFECTLY for searching cells for numbers. I thought maybe it fails because that is a number.īut I have hundreds of Excel files with Integer numbers stored in "General" format cells and I desperately need to be able to search them to see which files contain certain numbers. It will NOT find the file ! ! It will find a txt file or a doc file, but not xls files. Then under "A word or phrase in the file", type in: 123456 Then in Windows Explorer, right-click on C:\Temp and select "Search.
![windows explorer search for text in files windows explorer search for text in files](https://appuals.com/wp-content/uploads/2021/10/file-explorer.png)
I cannot find Excel files that contain specific strings.įor example, if I create a new file, and in the first cell type in "123456".