Custom functions
How to use and store custom functions in Excel
Today we’ll continue exploring custom Excel functions. Now that you know how to create UDFs, let’s dig a bit deeper and learn how to use and store user-defined functions in Excel. Continue reading
Debug user defined functions
As you already know how to create UDFs (and, I hope, you’ve also tried applying them in your Excel), let’s dig a bit deeper and see what can be done in case your user defined function is not working. Continue reading
How to remove whitespace and empty lines in Excel with Regex
Whichever input data you are using, you'll hardly encounter a dataset without spaces. In most cases, whitespace is good. In some situations, however, it may become evil - extra spaces can mess up your formulas and make your worksheets almost unmanageable. Continue reading
Custom UDF function vs VBA macros: advantages and drawbacks
This article will help you understand the differences between UDF and Macro. Also, custom functions have many advantages, but there are also many limitations when using them. Continue reading
How to extract substrings in Excel using regular expressions (Regex)
Microsoft Excel provides a number of functions to extract text from cells. Those functions can cope with most of string extraction challenges in your worksheets. Most, but not all. When the Text functions stumble, regular expressions come to rescue. Continue reading
Why is Excel User Defined Function not working?
This article shows how to add a help text to UDF and explains why these functions are not recalculated. You will see the differences between volatile and non-volatile custom functions. Continue reading
How to create custom user defined functions in Excel
This article will introduce you to user defined functions in Excel. You’ll see different variants of user defined functions and learn how to create and apply them. Continue reading
Excel Regex to remove certain characters or text from strings
Have you ever thought how powerful Excel would be if someone could enrich its toolbox with regular expressions? We have not only thought but worked on it :) And now, you can add this wonderful RegEx function to your own workbooks and wipe out substrings matching a pattern in no time! Continue reading
Excel Regex to find and replace strings using regular expressions
Microsoft Excel provides a number of options to replace one piece of text with another. Why would one want to complicate things with regexes? Because Excel's standard features can only process an exact string that you specify. Continue reading
Regex Match in Excel: regular expression matching with examples
When you need to find a certain value in a range of cells, you use the Excel MATCH function. When looking for a specific string in a cell, the FIND and SEARCH functions come in handy. And how do you know if a cell contains information that matches a given pattern? Obviously, by using regular expressions. Continue reading