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

Join first and last name in excel

In this article, we will learn about how to join the first and last name in Excel. In simple words, when working with names in data. Sometimes, we ...

How To Apply Borders In Excel

The borders make any picture a stand out of the crowd. They are also great tool for grouping same kind of object and area. In shorts, Borders are very...

How To Switch Rows and Columns in Excel

While working on excel many times you would want to flip table rows and columns. In that case, excel provides two methods. First is the TRANSPOSE func...

Scientific formatting in Excel

In this article, we will learn about how to use Scientific formatting in Excel. The Scientific format displays a number in exponential notation, re...

How to Use the Custom Format Cell in Excel

In this article, we will learn about how to use the Custom format cell option in Excel. Custom format option lets you change the format of 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 Google PlusVisit Us On Youtube