Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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- |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Pulldown that searches? | Excel Discussion (Misc queries) | |||
Getting valid web searches and avoiding sites that contaminate web searches | New Users to Excel | |||
select all worksheets in formula (wildcard) | Excel Worksheet Functions | |||
Workbook searches | Excel Worksheet Functions | |||
Searches | Excel Worksheet Functions |