mikedc1204 on October 14, 2014 08:18 AM
1. Open your workbook
2. Press control+F
3. Click options
4. In the "within: textbox, select workbook. This is sheet by default.
5. Under find what: type any text you want to search
6. Press find all
Excel will give you every cell in every sheets that it finds the text that you want to search, and will be
presented to you in an extension window, where you will just have to click the cell links and that cell will be
selected by excel for your further inspection.
Of course I can make a macro with this. But I think this excel tool is already sufficient.
If you want to process the text that you find for another tasks, then probably a macro is better.