Luckily, Excel offers handy formulas that ... you can quickly turn john doe into JOHN DOE. When converting entire ranges to upper case, you can use an array formula for efficiency.