Go far beyond Excel's native searching capability, with this powerhouse string and pattern search tool. Search by format/pattern, set custom character quantities and types, process multiple search phrases. A limitless arsenal to find what you need -- or to quickly process and extract data.
| Format | Platform |
|---|---|
| Add-in | Windows Excel |
Search for patterns using strings, character types, wildcards, and quantifiers
Input multiple phrases to perform an OR or AND search
Select character type
Select quantifier type
Select anchor type
Full pattern/format search tool
Multi-string AND/OR search - lists clickable results
Extract target data
Output search hits and counts
Reprint text with hits highlighted
- FORMAT SEARCH
- RegEx-based Format Search for patterns.
- Include or exclude character strings, character ranges, or character types/wildcards, with custom quantifiers including min/max limits.
- Select input column/s and search by row.
- Output hits & hit-counts in your worksheet, or reprint source cells with the target text highlighted.
- Select intuitive options from the drop downs, or direct input RegEx codes.
- Set Anchors, toggle case sensitivity, and set hit limit.
- Saves last used settings for convenient fine-tuning.
- MULTI SEARCH
- Easy to use multi-search with up to 3 inputs. Perform AND search to include all phrases, or use OR search to find cells containing any of the input phrases.
- View hits and click to navigate to the source cell.
- Search all sheets within a workbook, or just the active sheet.
- Toggle case sensitivity and Entire Cell searching.
Download - $4.99
Notes: Instructions/tips provided. One user per license.
Click the link below to start your download. Operating instructions are included in the xlsm file.
W384083