How to concatenate or merge in Excel

In this article, we will learn How to concatenate or merge in Excel. What is Concatenate in Excel? In General, there are two ways to combine d...

How to use the CLEAN function in Excel

In this article, we will learn how to use CLEAN Function in Excel. CLEAN function is a text function which removes the non printing characters and...

How to use the TRIMMEAN Function in Excel

In this article, we will learn about how to use the TRIMMEAN function in Excel to calculate the Average or mean for the range of values excluding va...

The Excel CONCAT Function

The new Excel CONCAT function is introduced in Excel 2019 and Excel 365. The CONCAT function simply adds given strings into one, just like CONCATENATE...

How to use the CONVERT Function in Excel

In this article, we will learn about how to use the CONVERT function in Excel. The CONVERT function converts the value of one measurement to anothe...

How to use the REPT function in Excel

The Excel REPT function is a simple function, that prints a given text to given times. In this article, we will explore how REPT function works, how R...

How to use the PROPER function in Excel

The PROPER function in excel is used to make text of Proper Case or say Title Case. The function capitalises first alphabet of each word in a cell. In...

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.