Convert Uppercase Text to Lowercase in Microsoft Excel 2010

In this article we will learn how we can convert uppercase into lowercase text in Microsoft Excel 2010. If you want to change the text from upperca...

How to highlight only text containing cells

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...

Using the Validation Input Message as a Cell Comment in Microsoft Excel

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...

Finding & Replacing in a Single Sheet or in All Sheets in Excel

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...

Selecting cells that only contain Text in Excel

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...

Counting How Many Times Specific Character Appears in Cell in Excel 2010

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...

Excel formula to extract the last word in a cell

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...

Terms and Conditions of use

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.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube