ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Find | (https://www.excelbanter.com/excel-discussion-misc-queries/182497-find-%7C.html)

muddan madhu

Find |
 
Hi all,

I have 100 excel files and I need to find some values say 1234.
How can i find in all the 100 files.

Can anyone knows ........ please make it fast ... I need urgently

Thanks

MartinW

Find |
 
I've never tried it but I believe Google Desktop will do that.
As I understand it, it allows you to use the google search
engine to search your own hard drive, and apparently
a lot quicker than Windows own internal search.

Check it out here
http://desktop.google.com/features.html

HTH
Martin



"muddan madhu" wrote in message
...
Hi all,

I have 100 excel files and I need to find some values say 1234.
How can i find in all the 100 files.

Can anyone knows ........ please make it fast ... I need urgently

Thanks




FARAZ QURESHI

Find |
 
One way is to:
Press (Windows Key)+F to start search;
Select All Files & Folders;
Insert the appropriate text you are searching for in the "A word or phrase
in the file";
Choose appropriate location in "Look in:";
Select "More Advanced Options";
In "Type of File" select "Microsoft Excel Worksheet"
You may also select the option "When Was It Modified?"
Hit Search!

Best of Luck


--

Best Regards,
FARAZ A. QURESHI


"muddan madhu" wrote:

Hi all,

I have 100 excel files and I need to find some values say 1234.
How can i find in all the 100 files.

Can anyone knows ........ please make it fast ... I need urgently

Thanks



All times are GMT +1. The time now is 05:15 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com