ExcelBanter - How do I search a text string in many excel worksheets (files)?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How do I search a text string in many excel worksheets (files)? (https://www.excelbanter.com/excel-worksheet-functions/70181-how-do-i-search-text-string-many-excel-worksheets-files.html)

TC628

How do I search a text string in many excel worksheets (files)?

I need to search many excel files to see if they contain a columns of numbers
in it.

This is like searching a string of text in multiple files in UNIX.

Does any one out there know how to do this?

Thanks.

TC628

All times are GMT +1. The time now is 07:15 PM.