View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Deeds Deeds is offline
external usenet poster
 
Posts: 113
Default Find a number in Excel file using search

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.

"Ms-Exl-Learner" wrote:

StartSearchSelect All Files and FoldersAll Part of the File Name:Type
*.xls OR *.xlsx OR *.xlsb OR *.XlsmA word or phrase in the Filetype the
character or word which is present inside the Excel FileLookinSelect 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.

--------------------
(Ms-Exl-Learner)
--------------------


"deeds" wrote:

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.