PROPER

Capitalizes the first letter of each word in Excel
Capitalizes the first letter in each word of a text value

Rational

Capitalizes the first letter of each word in a text string.

Description

The Excel PROPER function returns with capitalizing the first letter of each word in a given alphabetical text. For example, =PROPER(“michael jackson”) returns “Michael Jackson”.

Syntax

=PROPER (text)

Parameters

text – The text to convert into a proper case

Return Value

Text with proper case

Key Notes

  • The PROPER function capitalizes each word and every letter after numbers and punctuation characters in the string.
  • Use LOWER and UPPER functions for converting text to lower and uppercase respectively.
  • The PROPER function set the sentence to proper case.

Keep Reading Similar Functions:

Converts text to uppercase in Excel

UPPER

The Excel UPPER function converts all letters in the text to uppercase. E.g., “=UPPER(“Hello World”)” returns ” HELLO WORLD”.

Read More »
Convert string or text to Lowercase in Excel

LOWER

The Excel LOWER function converts all letters in the text to lowercase. For example, “LOWer” returns “lower”.

Read More »