View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] avilliers@gmail.com is offline
external usenet poster
 
Posts: 1
Default 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-