searching for text in multiple excel files

[roytom]

I need to search for text in multiple excel files - I've tried all kinds of tools - nothing works properly with excel files.



MS Office used to have an advanced search feature (in older versions) but this is not in ver 2010, it seems to just rely on windows search - which as far as I can tell does not include searching within files. And certainly not in excel files.

Any ideas?

Thanks, Roy

[Kimberly]

http://www.wikihow.com/Make-Windows-...-File-Contents

[roytom]

Excellent - many thanks. It now works.
R