4 ways to convert uppercase to lowercase in Excel without errors

You want to convert uppercase to lowercase or vice versa in Excel but you still don’t know how to do it. Don’t worry! Follow this article on 4 ways to convert uppercase to lowercase and you will know how to do it right away!

I. How to convert all uppercase letters to lowercase using the Lower function in Excel

1. LOWER function formula

The LOWER function converts all uppercase characters in a word to lowercase characters .

Eg: VALUES OF TIME will become values of time

You fill in the “(text)” position in a cell in Excel .

Eg: = LOWER(A1) ( in A1 contains the line VALUES OF TIME you want to transfer )

2. How to convert uppercase letters to lowercase letters

Step 1: Open the table in Excel with the content you need to convert > Write the formula =LOWER (blank cell containing the character you want to convert) into the cell you want to convert.

Step 2: Press Enter , the conversion result from uppercase to lowercase will appear in a flash.

Click on the cross icon to the right of that cell and drag down the lines below, the results will automatically appear for those cells.

II. How to convert all lowercase letters to uppercase letters using the UPPER function in Excel

1. UPPER function formula

The UPPER function converts all lowercase characters in a word to uppercase .

For example: THE GIOI DONG GAME APP PAGE will become the mobile world game app page .

Ex: = UPPER ( A1 ) (in A1 contains the line THE GAME APP THE GIOI DI DONG you want to transfer).

2. How to convert uppercase letters to lowercase letters

Step 1: Open the table on Excel with the content you need to convert > Write the formula =UPPER (blank cell containing the character you want to convert) at any position you want .

Step 2: Press Enter , the conversion result from uppercase to lowercase will appear.

Click on the cross icon to the right of that cell and drag down the lines below, the results will automatically appear for those cells.

III. How to convert the first character of a lowercase letter to uppercase using the PROPER function in Excel

1. PROPER function formula

The PROPER function converts the first character of a lowercase letter to uppercase .

Eg: microsoft excel will become Microsoft Excel .

PROPER function formula : =PROPER(text) .

Eg: = PROPER ( A1 ) (in A1 contains the line microsoft excel ).

2. How to convert uppercase letters to lowercase letters

Step 1: Open the table on Excel with the content you want to convert > Write the formula =PROPER (blank cell containing the character you want to convert) at any position you want .

Step 2: Press Enter , the conversion result from uppercase to lowercase will appear in a flash.

Click on the cross icon to the right of that cell and drag down the lines below, the results will automatically appear for those cells.

IV. Use Microsoft Word to convert uppercase to lowercase without formula in Excel

Step 1: Copy the content you want to convert on the Excel file > Paste the content into the Word file .

Step 2: Paste the content into the Word file > Select the table you just pasted > Go to the Home tab in the Font group and select Change Case (Aa icon right in the Font group)

Select 1 of 5 transfer methods .

1. Sentence case: Converts the first character in a sentence to uppercase.

Sentence case

2. lowercase: Convert all uppercase characters to lowercase.

3. UPPERCASE: Converts all lowercase characters to uppercase.

4. Capitalize Each Word: Converts the first letter of each word to uppercase.

5. tOGGLE cASE: Converts the first letter of a word to lowercase and the rest to uppercase.

Step 5: Then copy the table on Word and paste it on the Excel spreadsheet to complete the process .

The above article has introduced you to 4 ways to convert uppercase to lowercase in Excel without errors. Hopefully this information is useful to you. Please leave any questions below for our convenience. Good luck!

See more: 3 Simple Ways to Wrap Text in Excel