Add-Ins for Ms-Excel

This article cointain two add-ins. One is for a case-sensitive search (named searchm), and the second is one for a non-case sensitive search (named searchnm).

As you read this article, one question raised in your mind might be that, in Excel, there already is a built-in function available, so what is the use of this module or in what way does it differ from built-in search functions that are available in Excel? Do I need one or more function to get the correct answer? That is easy for a programmer to answer, but creates a great headache for normal people.

Example

In two string matches, the built-in search function is thin; it returns an index of matching strings, but what if it doesn't get a matching pattern? It genereates a #value! error to handle. You need one more function; this results in a complexity in use. The easy method is to use either of these two methods that directly result in either true or false, depending on the string follow pattern. With these add-ins, I provide a method of using it.

Add-Ins for MS Excel to Match Two Case-Sensitive Strings (searchm and searchnm)

In both searchm and searchnm, the functions are as follows:

# represents a single digit

? represents a single digit or char

* represents a zero or many digits or chars

To perform a non-case sensitive, the add-in name is searchnm. Use Formula 1 to conduct a non-case sensitive search with searchnm.

Top White Papers and Webcasts

Live Event Date: March 19, 2015 @ 1:00 p.m. ET / 10:00 a.m. PT
The 2015 Enterprise Mobile Application Survey asked 250 mobility professionals what their biggest mobile challenges are, how many employees they are equipping with mobile apps, and their methods for driving value with mobility.
Join Dan Woods, Editor and CTO of CITO Research, and Alan Murray, SVP of Products at Apperian, as they break down the results of this survey and discuss how enterprises are using mobile application management and private …

On-demand Event
Event Date: February 12, 2015
The evolution of systems engineering with the SysML modeling language has resulted in improved requirements specification, better architectural definition, and better hand-off to downstream engineering. Agile methods have proven successful in the software domain, but how can these methods be applied to systems engineering? Check out this webcast and join Bruce Powel Douglass, author of Real-Time Agility, as he discusses how agile methods have had a tremendous …