How to Merge Tables in Excel

A dataset is always structured. It means different entities have different tables. But many times we get need of merging tables in order too see relat...

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

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 Youtube