Download the featured file here:https://bluepecantraining.co.uk/how-to-change-case-in-excel-upper-lower-proper-with-or-without-formula/

In this Microsoft Excel video tutorial I explain how to change case in Excel. There's no button for this like there is in Word and PowerPoint, but Excel does provide many different ways of changing case.

️Timestamps
00:00 Introduction
00:28 Method 1: Flash Fill (no formula)
02:13 Method 2: Formula using UPPER, LOWER and PROPER
03:36 Method 3: Power Query (no formula)
04:58 Method 4: Copilot (Excel creates a formula for you)
06:07 Method 5: VBA Macro (changes case automatically on data entry)

#exceltips #exceltutorial