|
|
| inspector text is an Add-In for Microsoft Excel that adds several extremely powerful, yet easy to use, search & replace worksheet formula functions. Also adds functions for fuzzy matching, concatenated formulas, ordinal indicators, and more. |
|
| Updated |
May 17, 2009 04:18:53 | | Size | 2233 kb | | Licence | Shareware | | Status | Minor Update | | Languages | English | | Tags | Microsoft Excel, Add-In, Search, Replace, Regex, Regexp, Regular Expressions, Fuzzy Matching, Ordinal Indicator, Suffix, Text, Exclude, Extract | | OS | Windows 95, Windows 98, Windows ME, Windows NT, Windows 2000, Windows XP, Windows 2003, Windows Vista | | Homepage | precisioncalc.com | | Email | greglove@oz.net | | Author | Greg Lovern |
|
|
 click for full size
|
| Other author's software: | - xlPrecision 3.0 — Stop letting Excel round your numbers to 15 digits! Work with very large numbers in Microsoft Excel without them being automatically rounded. Eliminate Excel's stealthy binary conversion errors. Use vastly larger numbers than Excel allows on its own.
| | Show all author's software |
Description:
inspector text is an Add-In for Microsoft Excel that adds powerful worksheet formula functions for manipulating and working with text in worksheet cells, including search & replace, and fuzzy matching.
inspector text's search & replace functions are extremely versatile, flexible, adaptable, and detailed. They are vastly more powerful and useful than the search & replace functions built into Excel, yet are easy to use and do not require any special knowledge.
-- Use several powerful wildcards and substitutions.
-- Search from left to right or from right to left.
-- Restrict search to text that appears before (or does not appear before) other text you specify.
-- If replacing text, rearrange text as desired, instead of (or in addition to) replacing it.
-- Return any of 22 kinds of information about the text found.
-- Choose a friendly, custom text message to return if no match is found, instead of returning a standard error, if desired.
inspector text's fuzzy matching worksheet formulas allow you to determine whether or not the text in two cells is similar, or find the characters they have in common. They can also be used to find the text items in a list that are most similar to a target text item. Finally, you can easily find the needle in that haystack!
There is nothing else on the market like inspector text. Sure, other add-ins do menu-based search & replace and even simple fuzzy matching. But compare what you can do with inspector text in your worksheet formulas, and you'll never look back.
inspector text also adds worksheet formula functions that:
-- Exclude or retrieve lists of characters from text.
-- Return ordinal indicators for cardinal numbers ("1st" for 1, "2nd" for 2...).
-- Evaluate concatenated formulas (even if the arithmetic operator is text).
-- Perform Regular Expressions search and replace.
If you're a programmer, inspector text's functions can be called directly from your own programming code. | Short tags:
Microsoft Excel, Add-In, Search, Replace, Regex, Regexp, Regular Expressions, Fuzzy Matching, Ordinal Indicator, Suffix, Text, Exclude, Extract | System Requirements:
Microsoft Excel 97 or later | Change Info:
Eight new functions including Fuzzy Matching | |
| | Freeware alternatives inspector text 2.0.2b |
|  Free Download inspector text 2.0.2b from precisioncalc.com |
| Similar software shotlights: | - RegexBuddy 2.1.0 — Perfect companion for working with regular expressions. Easily create and clearly understand regex patterns. Test any regex on sample strings and files. Use the regex with automatic source code…
- PowerGREP 3.2.2 — Quickly search through large numbers of text and binary files, such as source code, correspondence, logs, ... to find exactly what you want. Search and replace with plain text or regular expressions…
| | Find all software similar on inspector text 2.0.2b |
| Similar smart reviews: | - RQ Search and Replace, Needles in a Haystack: Found, Replaced — What can be easier than editing a file? — Simply open it and replace a block of text with a better one. Well, true, if there’s just one file to be edited. But doing the same with a few or, even better, a whole bunch of files that require the same replacement? Then you’ll need something like a batch editing tool. A great choice…
- HandyFile Find and Replace: Text Workbench — Imagine creating a large website consisting of dozens or hundreds of pages with the company’s name topping each of them and lots of identical links in the HTML code. Now imagine that your client urgently requests that these links be modified due to the change of the site address and that the company’s name has to be written in a slightly different manner due…
- Interface Traffic Indicator 1.5.0.2, Just Monitoring — There’s a really simple idea lying under the Interface Traffic Indicator software, yet the software built on the idea is excellent. The idea is: You have a computer, or a network, where you’d want to monitor the amount of the network traffic. It can be done in many different ways with different levels of complexity and reliability, but the Interface Traffic…
- aZebra Search Server. Search It! — Life is a constant search. We search for necessary information everywhere. Now, with the advent of the Internet, it’s become possible to find information about just whatever we want. All we need for that is a powerful search server like @Zebra. @Zebra is a universal search server that can help you to find things inside local networks, on ftp servers or you can just…
- IconScanner 2.1.1, Extract From Everywhere! — IconScanner helps to review images contained inside files of any type and then extract and convert the found images. In IconScanner you have the habitual explorer-like disk browser (with folders to the left, files and subfolders to the up-right), but under the list of files you see all images contained in those files! «All» means really «all», as IconScanner easily extracts…
- Sothink SWF Decompiler 3.7, Extract Everything — Examining what things are made of is human’s eternal passion. Examining what computer things are made of is even more attractive. Examining what Flash movies and games are made of can be useful and even necessary (while remaining so attractive!) Sothink SWF Decompiler fulfils this passion completely. Sothink SWF Decompiler can help you to examine any SWF file in details and convert…
- Excel Workbook Splitter 1.05, Fastest And Easiest Way — Trends in today’s software industry have brought us many monster-like huge «suites». In fact, «multifeatured and universal software suites» take any niche where enough users can be found. It is not that bad, these suites are typically really useful and pleasant to use, but they don’t suit many situations, when you need to do one easy operation but many times…
- Excel Merge Tool: Few Clicks that Save Hours — Merging a report out of a multitude of Excel spreadsheets is quite a challenge. Although data from a couple of spreadsheets could be merged by hand, with the copy/paste command and a bit of patience, merging data from a few dozens or hundreds of tables requires totally different approaches. Excel Merge Tool provides the functionality you need to merge…
- TeX Expressions Put in Human-Readable Format. BaKoMa TeX. — Just as hard as to learn a new foreign language — is for a newbie to code a mathematical formula with TeX. It requires remembering a handful of tricky expressions and totally wears out on debugging the code: TeX provides no way to see whether or not the formula you have typed is syntactically correct, and the expression you’ve just…
| | Find all smart reviews similar on inspector text 2.0.2b |
|
