Find a number in Excel file using search

  • Thread starter Thread starter deeds
  • Start date Start date
D

deeds

I am trying to do a Windows search to find an Excel file containing a
specific number. I have looked everywhere...no luck. I did the File Search
option within Excel...no luck. There has to be a way to do this...any ideas?
Thanks.
 
Are you sure said "specific number" actually exists? A lot of time cell
formatting shows a "view" of a number not the actual number.
 
Start>>Search>>Select All Files and Folders>>All Part of the File Name:>>Type
*.xls OR *.xlsx OR *.xlsb OR *.Xlsm>>A word or phrase in the File>>type the
character or word which is present inside the Excel File>>Lookin>>Select the
Drive if you know it exactly, Otherwise select My Computer from the Drop Down.

* means that the file may contain any name.
*.xls OR *.xlsx OR *.xlsb OR *.xlsm will make the search to go through only
with Excel files other than looking in all files. If you are using Excel 2003
then use the extension as *.xls in All part of the File Name.
 
That does not work. I have a test file created with the number 12345 in one
cell located in a specific folder. It does not find it.
 
Yes some time the search wont work eventhough the File consist the Character
or word in some machines. Try to search it in some other system if the
Folder or File if it is located in server.

Remember to Click Yes, if this post helps!
 
I am trying to do a Windows search to find an Excel file containing a
specific number.  I have looked everywhere...no luck.  I did the FileSearch
option within Excel...no luck.  There has to be a way to do this...any ideas?
 Thanks.
Click to expand...

Are you using Start>Search or Windows Search with the installed
application?

You can install Windows Search from Microsoft which should scan all
excel files and return what you're looking for.

HTH,
Reeza
 
Back
Top