How to Use PROPER Function

by Best Excel Tutorial Functions

The PROPER function in Excel is used to capitalize the first letter of each word in a given text string, and convert all other letters to lowercase. Here’s how to use the PROPER function in Excel:

  1. Start by selecting the cell where you want the output to appear.
  2. Type “=PROPER(” into the cell.
  3. Within the parenthesis, type the reference to the cell or the text string you want to capitalize the first letter of each word.

For example, if you have a name in cell A1 and want to capitalize the first letter of each word in that name, you can use the following formula in a different cell:

=PROPER(A1)

proper function best excel tutorial

The output will display the name with the first letter of each word capitalized and all other letters in lowercase.

Note that the PROPER function does not capitalize the first letter of a word following a hyphen or an apostrophe. If you want to capitalize those letters as well, you may need to use a combination of the PROPER function with other functions like SUBSTITUTE, UPPER, or LOWER.

Related posts:

Excel database functions exampleHow to Use Database Functions in Excel Finding a Single FrequencyHow to Calculate Frequency in Excel Default ThumbnailHow to Vlookup other Tab in Excel?
See also  How to Use Countif Function in Excel