Formula for changing all caps in excel?
Score: 4.2/5 (73 votes) 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.How do I change all text caps in Excel?Next to the column or row that contains the text you would like to chang...