Extract Text From A String In Excel Using Excel’s LEFT And RIGHT Function

Data extraction and cleaning is the first and most crucial task of any data analysis project. In my five years of experience, I have received data tha...

Reducing file size in Microsoft Excel

In this article, we will learn how we can reduce the used area in a sheet in Microsoft Excel. The vertical scroll bar gets shorter as the used area of...

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

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