Select first cell Here A2. Text needs to be enclosed in quotation marks a formula that returns text or a reference to a cell containing the text you want to partially capitalize. For illustration we have included a simple table containing field.
Text needs to be enclosed in quotation marks a formula that returns text or a reference to a cell containing the text you want to partially capitalize.
Syntax PROPER text Arguments. The PROPER function will help us convert text into the proper case if required. We can use it to capitalize each word in a given string. Proper Excel function is used to make the given input in proper case proper case means in a word the first character is in uppercase while the rest of the characters is in lower case for instance in a name of a person we use this formula to make it in proper case to use this function type PROPER and provide string as input.