In this article we will learn how to apply conditional formatting in cell. To apply Conditional formatting based on text, we use the Conditional Fo...
The Data Validation is used for making the data error free. It is a technique in Microsoft Excel by which we can control the input by providing the d...
You can find specific text, numbers, and formulas in current worksheet and all worksheet of a workbook by using the key “CTRL + F”. You can replac...
To select specific cells that only contain text, we can use the Go-To option or Conditional Formatting in Excel. Let’s take an example and understa...
In this article we will learn counting how many times specific character appears in excel 2010. To return the count of specific character in a cel...
To extract the last word from the text in a cell we will use the “RIGHT” function with “SEARCH” & “LEN” function in Microsoft Excel 20...
To extract the first, middle and last name we use the formulas "LEFT", "RIGHT", "MID", "LEN", and "SEARCH" in Excel. LEFT: Returns the first charac...
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.
