upper/lower/proper function – amend the case of cell text

Use the UPPER and PROPER functions to make any text content in Excel look more presentable.

The entered in the example below is not in the correct case for displaying names

Proper1

The PROPER function will convert the text into the correct case for displaying names

Proper2

 

By using the UPPER function, all text can be converted to upper case
Proper3

Get more great content from Rousseau Associates

Start your project with us today

Call +44 (0)1757 269461

Discuss your requirements today