Change Text to LOWER Case in MS Excel using Function

Change Text to LOWER Case in MS Excel using Function

=LOWER()

Using Excel's LOWER Function we can change the text case of any type to lower case.

Here, we referred the data from the cell above and converted the text's case to LOWER case.

Example 1

Using LOWER function, refer the cell with data and press enter.

Example 1

In this example we directly added the sample text within the function and converted the text's case to LOWER case.

Example 2

Using LOWER function, directly add text within the function and press enter.

Example 2

The LOWER function comes in handy when merging large data from different source, made in different text cases.

Tip

The input content can be any text case, or even multiple types of text case, the ultimate output will be LOWER case.

Tip

Once converted you can then copy the lower case text and paste it as value, so that you get the text in lower case instead of copying the formula.

Tip

Change Text to LOWER Case in MS Excel

Read more