Change the case of text in Excel To change column A to Title Case, select cell B2. Type =PROPER(A2), and press Enter. Tip: Use the formula =UPPER(A1) for all UPPERCASE; =LOWER(A1) for all lowercase. Now fill down the formula through cell B10.