|
|
Home : Business : Office Suites & Tools
inspector text
inspector text Details:
| Publisher:
|
PrecisionCalc |
| Version:
|
1.0 |
| License:
|
Shareware |
| Price:
|
$12.00 |
| Operating Systems:
|
Win95,Win98,WinME,WinNT 4.x,Windows2000,WinXP |
| System Requirements:
|
Microsoft Excel 97 or later |
| File Size:
|
2.21 MB |
| Total Views:
|
498 |
| Total Downloads:
|
0 |
| Rating:
|
 (4 out of 5 Stars) |
| Release Date:
|
1/25/2006 |
| Last Update:
|
2/27/2006 |
|
|
inspector text Short Description:
Extremely powerful search & replace worksheet formula functions for MS Excel.
|
inspector text Long Description:
inspector text is an Add-In for Microsoft Excel that adds several extremely powerful, yet easy to use, search & replace worksheet formula functions:
-- Use several powerful wildcards and substitutions.
-- Search from left to right or from right to left.
-- Choose whether search is case sensitive or not.
-- Restrict search to text that appears before (or does not appear before) other text you specify.
-- Offset both the position and the length of the text found by any amount.
-- If replacing text, choose whether to replace only the first matching string found, or to replace all matching strings found.
-- 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, such as position, position from right, text string found, count of all text strings found, array of all text strings found, etc. etc.
-- Choose a friendly, custom message to return if no match is found, instead of returning a standard error, if desired.
inspector text also adds worksheet formula functions that exclude undesired characters from text, and that retrieve desired characters from text, and that exclude non-numeric or retrieve numeric characters from text including negatives in parentheses and numbers in exponential notation.
inspector text adds a worksheet formula function that performs Regular Expressions search and replace.
inspector text also adds a worksheet formula function that evaluates concatenated formulas in which the operator is text (such as "1+2", where everything including the "+" is text).
inspector text adds another worksheet formula function that returns ordinal indicators for cardinal numbers (it returns "1st" for 1, "2nd" for 2, "3rd" for 3, etc.)
inspector text also provides online help from Excel's Tools menu, and utilizes Excel's Insert Function dialog to make using inspector text function
|
inspector text Keywords:
Microsoft Excel Add-In Search Replace Regex Regexp Regular Expressions Ordinal Indicator Suffix Text Exclude Extract
|
Other Software Products by PrecisionCalc:
1) xlPrecision
|
|
We deliver articles like below right to your inbox for free:
What's New in ERP Software
by Www. Pingasolutions.Com
There exist different types of ERP software for altered industries and an equally huge number of ERP providers too. But, ERP is a domain that needs constant upgradation, depending on changing business perspectives. ERP developers need to constantly work on their software to give it an edge in the highly competitive industry. This article distinctively focuses on the Real Estate ERP software, their latest features, compensation, development in ERP functioning, etc. The real estate...
Data Loss and its Consequences
by Mark Robin
When the data loss happens and the user in fact incur the losses that he/she able to know, the real extent of the loss of their business. Generally the large organization, due to the sheer nature of their inter-entity dependencies, is likely to face the tougher time during the data loss disaster than small firms.For a long time, business and individual computer users never appreciated the magnanimity of the data loss disaster. While occasional virus attacks used to affect the business...
Technology Makes Our Business Communications Faster
by Corazon Padol
Technology today can be quite overwhelming. There are a lot of new devices, systems, and equipment that are changing the way we live now. New technology brings about new ideas, and with a fast paced lifestyle, many people are becoming more dependent on technology, for it can make the way we do things faster. One important advantage of technology is having faster communications between the two ends. From state of the art cellular telephones that has access to the Internet, to high end vid...
Adobe unveils new community site & Acrobat new version
by Pattrick Savarna
It isn't only Google that is challenging the Microsoft's on-premise Office and SharePoint productivity and collaboration suites with hosted, online versions of similar applications. Adobe has made a move into on-line document sharing sector. Acrobat announced its community site at the same time when the newer version of Adobe's Acrobat software with flash player is launched. Adobe Acrobat 9 Pro Extended Adobe Acrobat is considered the almighty force in PDF software. The beta ve...
Cathay's CCIE Security Lab Training
by Fandy Du
1, CCIE Lab Training The location for CCIE Lab Training can be sit at Guangzhou or Dalian, China. There are two tracks for CCIE Security lab training, one is called Intensive Track (CSLT-I), which takes 14 days to have it done, the other is called Fast Track (CSLT-F) which probably takes 18 days. Pre-class requirement for taking <a href=...
|
Recommended Products:
|
|
|
|
|