How to Change Text Case in Excel | Excel Text Functions

Learn how to use Excel’s text case functions like UPPER, LOWER, and PROPER. Easily change text case for efficient data formatting and analysis.

Change the case of Text

LOWER function: Converts all uppercase letters in a text string to lowercase.

Syntax:

LOWER(text)

The LOWER function syntax has the following arguments:

Text Required. The text you want to convert to lowercase. LOWER does not change characters in text that are not letters.

UPPER function: Converts text to uppercase.

Syntax:

UPPER(text)

The UPPER function syntax has the following arguments:

Text Required. The text you want converted to uppercase. Text can be a reference or text string.

PROPER function:

See also:

Exercise : Lowercase Conversion

Create a new worksheet.
In cell A1, type "PYTHON PROGRAMMING IS FUN."
In cell B1, use the LOWER function to convert the text in cell A1 to lgowercase. The formula should look like this: =LOWER(A1). B1 should display "python programming is fun."

Exercise : Proper Case Conversion

Open a new Excel worksheet.
In cell A1, type "muhammad ahmad."
In cell B1, use the PROPER function to convert the text in cell A1 to proper case. The formula should look like this: =PROPER(A1). B1 should display "Muhammad Ahmad."

Exercise : Change the following text to uppercase.

This is a sample text.

Exercise: Change the following text to lowercase.

THIS IS A SAMPLE TEXT.

Exercise : Change the following text to title case.

this is a sample text.

Exercise : Create a new column called "Title Case" and use the PROPER function to convert the text in Column A to title case.

Sample Data: