Excel Text 2 of 4: Change Case

Changing case is easily accomplished using Excel’s text functions.

UPPER	convert to upper case	=UPPER(“Kanye”) returns KANYE
LOWER	convert to lowercase	=LOWER(“KIM”) returns kim
PROPER	convert 1st  letter of each word to uppercase	=PROPER(“north west”) returns North West

Convert Text to Uppercase

1. In a blank cell enter =UPPER( text ), where text refers to the cell containing text to reformat. A copy is created in uppercase.
2. Select the newly created copy and press CTRL+C (Copy).
3. Select original cell.
4. RIGHT+CLICK and select PASTE VALUES.

For 45 second video, click here:

Cheers!

hɔuᴉnb

Additional reading:

• Excel Text Functions 1 of 4: =LEFT() and =RIGHT()
• Excel Data Consolidation
• More Excel Tips