Please note javascript is required for full website functionality.


A to Z of Excel Functions: The PROPER Function

18 March 2024

Welcome back to our regular A to Z of Excel Functions blog.  Today we look at the PROPER function.


The PROPER function

The PROPER function capitalises the first letter in a text string and any other letters in text that follow any character other than a letter.  It converts all other letters to lowercase letters.

The PROPER function uses the following syntax to operate:


The PROPER function has the following argument:

  • text: this is required and represents the text enclosed in quotation marks, a formula that returns text or a reference to a cell containing the text you wish to partially capitalise.

Please consider my following example:

We’ll continue our A to Z of Excel Functions soon.  Keep checking back – there’s a new blog post every other business day.

A full page of the function articles can be found here