Search for Words in a File

An Excel file that teaches how to perform Search for Words in a File operation.

Excel Source: Search for Words in A File

The expression to be searched is taken from the parameter cell. A loop is established over all pages. Matches are reported as a list. The cell addresses found are recorded. The results are shown in the summary table.

Hope it is useful.