Change Case

7 lessons in order

Change lowercase to uppercase in Excel without formulas using Flash Fill, VBA code, or Microsoft Word for quick and easy text transformation.

Learn how to capitalize the first letter of a sentence in Excel using Flash Fill, formulas, Power Query, or VBA to format text efficiently.

Learn how to change uppercase to lowercase in Excel using the LOWER function, Word, VBA, Power Query, or by keeping only first letter capital.

Learn how to capitalize the first letter of each word in Excel using the PROPER function, Flash Fill, or a custom VBA macro.

Learn how to change case in Excel without formulas using VBA macros, Power Query, or Word’s Change Case tool for quick text formatting.

Learn how to change sentence case in Excel using formulas or VBA macros to quickly convert text into proper formatting styles.

Learn how to capitalize all letters in Excel without formulas using Flash Fill, fonts, Word formatting, or VBA automation methods.