As Seen on TechCrunch: Finofo Raises $1.65M CAD!

Excel Guide

How to Change Letter Case in Excel

If you wish to alter the letter case to all uppercase or proper case in Excel, there are various methods available. You can utilize the UPPER function, the Proper function, or even combine both to achieve the desired outcome. This guide illustrates how to employ these approaches effectively.

Using the UPPER Function

The UPPER function, a built-in feature in Excel categorized under String/Text Functions, can be used as both a worksheet function (WS) and a VBA function (VBA). To apply the UPPER WS function, select a cell and type "=UPPER(" followed by the cell reference or text string enclosed in double quotes.

Using the Proper Function

Similarly, the Proper function in Excel, also classified under String/Text Functions, can function as a worksheet (WS) or VBA function (VBA). By typing "=Proper(" along with the cell reference or text string enclosed in double quotes, one can convert text to proper case.

Utilizing a Combination of UPPER and Proper Functions

Combining the UPPER and Proper functions allows for converting text to proper case from uppercase. For instance, the formula "=PROPER(UPPER(A1))" first changes the text to uppercase using the UPPER function and then to proper case using the Proper function.

Employing the Text to Columns Feature

Another method involves using the Text to Columns feature to convert all letters to proper case. This feature can split text-containing cells into multiple columns and transform text to proper case.

Using a Macro

To convert text to proper case regularly, creating a macro is efficient. By following specific steps to write a macro code, one can apply the ConvertToProper function in a worksheet formula, converting text to proper case seamlessly.