Find a number in Excel file using search
 

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.

Find a number in Excel file using search
 

Are you sure said "specific number" actually exists? A lot of time cell
formatting shows a "view" of a number not the actual number.

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.

Find a number in Excel file using search
 

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.

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.

Find a number in Excel file using search
 

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!

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


"deeds" wrote:

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.

Find a number in Excel file using search
 

On May 14, 8:39*am, 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.

Are you using StartSearch 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