LOWER Function Archives

How to Capitalize Each Word in Excel (7 Ways)

Apr 6, 2022 Excel Formulas

When we work on an Excel worksheet, sometimes we have to capitalize each word in a text. If you are facing any difficulties in doing that job, then ...

How to Format Text to Capitalize First Letter in Excel (10 Ways)

Mar 16, 2022 Excel Basics

Sometimes there is data in the Excel worksheet where the letter case is wrong or not in the format that you want. In this article, we will show you ...

How to Convert Scientific Notation to Number in Excel (7 Methods)

May 25, 2022 Excel Basics

In Microsoft Excel, there could be cases where we need to change the Scientific Notation to Text format to show the number in full length. One of the ...

How to Use Excel EXACT Function (6 Suitable Examples)

May 18, 2022 Excel Basics

The Excel EXACT function tests two text strings and returns TRUE or FALSE depending on their exact match or otherwise respectively. The EXACT ...

How to Compare Addresses in Excel (11 Easy Methods)

May 17, 2022 Excel Formulas 1

To perform any data analysis task comparing data in excel is common. It is most required for banks to check the background of a customer depending on ...

Excel Count Specific Characters in Cell (4 Quick Ways)

May 16, 2022 Excel Formulas

Sometimes we need to count only the specific characters in an Excel cell. Different excel functions make this easy for us. In the article, we are ...

Count the Number of Specific Characters in a Cell in Excel (2 Approaches)

May 16, 2022 Excel Formulas

While dealing with MS Excel you might need to count the number of specific characters in a cell in Excel. There are several techniques to perform ...

How to Merge Text from Two or More Cells into One Cell (Easiest 6 ways)

May 14, 2022 Excel Basics

If you are looking for some simple and easiest ways to merge text from two or more cells into one cell, then you are in the right place. Merging ...

How to Use LOWER Function in Excel (6 Easy Examples)

Feb 24, 2022 Excel Formulas

MS Excel provides us with various functions to help us customize the case of the text. Among them, the LOWER function is used to change the case of ...

Excel Find Similar Text in Two Columns (3 Ways)

Feb 24, 2022 Excel Formulas

Depending on the circumstances you may need to find similar text within two columns in Excel. Today, we are going to show you how to find similar ...