How to use Excel LOWER Function in Office 365? – Simple Steps!!
Tags: excelfunctions, lowerfunctioninexcel, excel, excelturorials
Published: 2020-12-15 09:20:18

---
title: How to use Excel LOWER Function in Office 365? – Simple Steps!!
published: true
date: 2020-12-12 08:20:00 UTC
tags: ExcelFunctions,LOWERFunctioninExcel,Excel,Excelturorials
canonical_url: https://geekexcel.com/how-to-use-lower-function-in-microsoft-excel-365/
---

## LOWER Function:

We all know that there are two kinds of cases in letters such as **[uppercase](https://geekexcel.com/how-to-use-upper-function-in-microsoft-excel-365/) (Capital letters)** and **lowercase (small letters).** If you want to convert all the uppercase letters to lower case, what will you do? The **LOWER Function** in Excel will make your work easier. It will convert all letters in the specified **string** to lowercase.

In this article, let’s start to discuss the explanation, basic syntax, and usage of the **LOWER**  **function** in **Excel Office 365**. Get the official version of  **MS Excel**  from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)
## **Explanation of LOWER Function:**

- The **LOWER Function** in Excel returns a **lower-case version** of a given **text string**.
- This Function will not affect by the **Numbers and punctuation**. It can be used as a **worksheet function (WS)** in Excel.
- As a worksheet function, the **LOWER function** can be entered as part of a formula in a cell of a worksheet.

## **Basic Syntax of LOWER Function:**

```
**=LOWER(text)**
```

### **Argument Description:**

- **Text** – The string that you wish to convert to **lowercase.**

## **LOWER Function – Practical Examples:**

Now Let’s see some examples of **LOWER**  **F**** unction** and analyze how it works in Microsoft Excel.

**Example 1: **

- In **cell B5** the input has been entered.
- The formula is entered in the output **cell D5.**
- The below-mentioned screenshots are the **two ways** of using the formula.

![Using Formula](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/03/Screenshot_8.png)<figcaption id="caption-attachment-4316">Using Formula</figcaption>

![Using formula other way](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/03/Screenshot_1-10.png)<figcaption id="caption-attachment-4317">Using formula another way</figcaption>

- Press **Enter** to calculate the **output**.
- Here the below screenshot is concerned with the different examples of the **LOWER function.**

![Examples](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/03/Screenshot_2-6.png)<figcaption id="caption-attachment-4318">Examples</figcaption>

**Example 2: Incorrect Formula turns into Error **

- If the **Formula** has been entered wrongly, then it will show as an error. Check out the below screenshots.
- Here I have given the space between **= and the LOWER** & also given the space between **LOWER and the B5**.
- Then click enter the output will be under **error.**

![Incorrect Formula](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/03/Screenshot_3-7.png)<figcaption id="caption-attachment-4320">Incorrect Formula</figcaption>

![Error](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/03/Screenshot_4-7.png)<figcaption id="caption-attachment-4321">Error</figcaption>

## **Verdict:**

In the above article, we have discussed the **explanation, basic syntax, and usage** of the **LOWER Function** with a few practical examples. Is this article is useful? then kindly drop your valuable **suggestions/queries** in the comment box & Don’t forget to leave your **worthwhile Feedback**.

Thanks for visiting **[Geek Excel!!](https://geekexcel.com/)** Keep Learning with us!!

## Related Articles:

- [**YEAR Function in Excel**](https://geekexcel.com/how-to-use-year-function-in-excel-365/) ** **
- **[TODAY Function in Excel](https://geekexcel.com/how-to-use-today-function-in-excel-365/)**
- **[ABS Function in Excel](https://geekexcel.com/how-to-use-abs-function-in-microsoft-excel-365/)**
- **[DATE Function in Excel](https://geekexcel.com/how-to-use-date-function-in-microsoft-excel-365/)**
- **[DATAVALUE Function in Excel](https://geekexcel.com/how-to-use-datevalue-function-in-excel-365/)**
- **[SUM Function in Excel](https://geekexcel.com/sum-function/)**
- **[CODE Function in Excel](https://geekexcel.com/how-to-use-code-function-in-microsoft-excel-365/)**
- **[SECOND Function in Excel](https://geekexcel.com/how-to-use-second-function-in-microsoft-excel-365/)**
- **[DAY Function in Excel](https://geekexcel.com/how-to-use-day-function-in-excel-365/)**
- **[HOUR Function in Excel](https://geekexcel.com/how-to-use-hour-function-in-microsoft-excel-365/)**
- **[ADD Function in Excel](https://geekexcel.com/how-to-create-custom-add-function-in-excel-365/)**