TextAfter function in Excel is used to extract text based on the given condition after a character, word, delimiter, multiple delimiters. Additionally, the TEXTAFTER function can extract text from backwards as well. Return a specific value in case if delimiter is not found.
Most of the excel users are familiar with the VLookup Function. How to use it, What are the advantages and limitations of the VLookup Function. Microsoft has introduced a new powerful function as a successor to VLookup which is the XLOOKUP function. In this article let us learn about the XLOOKUP function in excel in …
How to use XLOOKUP function In Excel – A Complete Guide Continue Reading »
When working with data in excel, we see the same data repeat multiple times. In other words, we see duplicate entries in data. If you want to do data analysis the first step you need to do is to remove these duplicate entries. If not then you will end up getting up incorrect results. This …
UNIQUE Function in Excel – Best way to Remove Duplicates Continue Reading »
Match function is one the most important and widely used functions in Excel. In this post let us see how to use the Match Function in excel. Syntax of Match function and few examples on how to use the Match function in excel. What is MATCH Function in Excel Match Function in Excel is under …
How to use MATCH Function in Excel – Syntax and Examples Continue Reading »
There are hundreds of functions in MS-Excel. There are a few of them which we use frequently and INDIRECT function is one among them. Indirect function is under the category of lookup or reference function. Let us know the importance of indirect function and see how to use Indirect function in excel and its usage …
How to use INDIRECT function in Excel – Complete Guide Continue Reading »
Understanding Cell References in Excel is one of the important things to master excel and make the most out of spreadsheets. Cell References combined with auto fill feature of excel help you to reduce/ eliminate the dirty manual work. To begin with cell references in excel, we need to understand what a cell is and …
How to use Cell References in Excel – Relative, Absolute and Mixed Continue Reading »
In this post let’s know about the OFFSET Function in excel. Also, the Syntax, how to use along with limitations and alternatives to OFFSET function. What is “OFFSET” Function in Excel OFFSET function returns the value of a cell/ range that is a specified number of rows and columns away from a cell or range …
