Zero padding to the week numbers in Excel

In this article, we will learn about how to pad zero with week numbers in Excel. WEEKNUM function returns the week number of a year. There are 53 w...

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

Remove matching characters in Text

In this article, we will learn about how to remove matching characters in Text in Excel. In simple words, while cleaning numbers to get just the numb...

Double quotes inside a formula in Excel

In this article, we will learn about how to add Double quotes inside a formula in Excel In simple words, we use text in double quotes in Excel to l...

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