Share on twitter
Share on linkedin
Share on facebook
Share on pinterest
Share on email
Share on print
Share on twitter
Share on linkedin
Share on facebook
Share on pinterest
Share on email
Share on print

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 »