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.
In this article let us see how to enable Developer Tab in Excel with detailed step by step process. What is the Developer Tab in Excel The Developer Tab in Excel is the gateway to use or open The VBA Editor – To Create/ Modify/ Run Macros Use ActiveX Controls Create forms or Use Form …
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 …
This article explains about creating and using drop down list in excel using data validation. Why in survey’s we will see options are limited (majority of the cases) where in the user can choose his/ her option from the available list of options. The answer is simple and well known. An organized/ properly formatted data …
Drop Down List in Excel – How to create and use using Data Validation Continue Reading »
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 »
Excel is not a typing program as it is majorly used to work with numbers and analyzing data. However all your efforts go in vain if there are typos or spelling mistakes in the representation of data. This comes as a challenge for many users to identify and correct the spelling mistakes or typos in …
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 »
