Replace text from end of a string starting from variable position

The Excel REPLACE function is used to replace a certain length of text from a given string. We define the starting position, the number of characters...

Replace text from beginning of a string to variable position

The Excel REPLACE function is used to replace a certain length of text from a given string. We define the starting position, the number of characters...

How to Count Specific Character in a Range

We know that the total characters in a cell can be counted using the Excel LEN function. We also have learned how to count total characters in a range...

How to Count Total Characters in a Range

We know that the total characters in a cell can be counted using the Excel LEN function. Now to count total characters in range (more than one cell), ...

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

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