Convert text to lower and upper case in Excel

This example will teach you how to convert a text string to uppercase or lowercase, as well as convert it to text where each word starts with a capital letter.

1. Use the function LOWER (LOWER) to convert all letters in a text string to lowercase.

   =LOWER(A1)

   =СТРОЧН(A1)

2. Use the function UPPER (UPPER) to convert all letters in a text string to uppercase.

   =UPPER(A1)

   =ПРОПИСН(A1)

   

3. Use the function PROPER (PROPER) to convert a text string to text where each word starts with a capital letter. That is, the first letter of each word is in uppercase, and all the rest are in lowercase.

   =PROPER(A1)

   =ПРОПНАЧ(A1)