Wildcard Searches across Worksheets
I need to be able to find the following patterns within my data -
usually within an entire workbook or worksheet:
Annnn (or B3425 as an example)
A = any letter A-Z
n = any number 0-9
This pattern would normally be found repeated in one column of any
worksheet but sometime they get scattered around thus the need to
search the whole workbook/sheet.
Using Excel 2003 here.
Is anyone familiar with using functions to code this or possibly an
add-in? Thanks.
-Alan-
|