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.
To sort our data majority of us use the Sort option available on the Home tab or Data tab to sort the data in excel. Do you know that there is a function in excel to sort our data as required. In this article let us learn about the excel SORT function. How to use …
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 »
In this article let us understand about the Excel COLUMN Function. The Formula Syntax of Column Function in Excel. What is Excel Column Function The purpose of Excel Column function is to know or get the column number for a given cell or range. This function returns the column number(s) depending on the input. Note …
In this article let us understand about the Excel Row Function. The Formula Syntax of Row Function in Excel. What is Excel Row Function The purpose of Excel Row function is to know or get the row number for a given cell or range. This function returns the row number(s) depending on the input. Note …
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 »
