The LOWER, UPPER and PROPER case-conversion functions in Excel

In the text function group, the text conversion functions in the text are quite necessary and often used when manipulating, processing text and strings.

In the text function group, the text conversion functions in the text are quite necessary and often used when manipulating, processing text and strings.

The following article introduces you to three font conversion functions: LOWER (), UPPER () and PROPER ().

The LOWER, UPPER and PROPER case-conversion functions in Excel Picture 1The LOWER, UPPER and PROPER case-conversion functions in Excel Picture 1

1. LOWER.

Description

The LOWER () function converts all the characters in the text string into lowercase, helping you to reformat the text string.

Syntax

= LOWER (text)

Inside:

text is the text you want to convert to lowercase. Text can be a reference to a text string or a text string.

For example

The LOWER, UPPER and PROPER case-conversion functions in Excel Picture 2The LOWER, UPPER and PROPER case-conversion functions in Excel Picture 2

2. UPPER.

Description

The UPPER () function helps you convert all characters in a text string (text) into uppercase.

Syntax

= UPPER (text)

Inside:

text is a text string you want to convert all characters to uppercase. Text can be a reference to a string or a string.

For example

The LOWER, UPPER and PROPER case-conversion functions in Excel Picture 3The LOWER, UPPER and PROPER case-conversion functions in Excel Picture 3

3. PROPER.

Description

The PROPER () function capitalizes the first letter in a text string if it's a non-letter character (for example, a space) and converts all other letters to lowercase.

Syntax

= PROPER (text)

Inside:

text is the first string to capitalize and is a required parameter. Text can be a text string, a formula that returns text, or a cell reference to the text string in uppercase.

For example

The LOWER, UPPER and PROPER case-conversion functions in Excel Picture 4The LOWER, UPPER and PROPER case-conversion functions in Excel Picture 4

Thus, when encountering cases that require you to convert the font in a certain style, you can quickly apply these conversion functions appropriately. Good luck!

4.5 ★ | 2 Vote