PROPER function in Excel

PROPER () function in Excel During the process of importing data in Excel, sometimes because of fast typing, you skipped capitalizing the first letter of the data. Instead of spending time fixing each data, you can use the PROPER () function to save repair time. The PROPER () function will help you capitalize the first letter of words and convert all other characters to lowercase.

For the syntax and usage of the PROPER () function, follow the article below.

PROPER function in Excel Picture 1

Description

The PROPER () function capitalizes the first letter in a text string if it's a non-letter character (for example, a space) and converts all other letters to lowercase.

Syntax

= PROPER (text)

Inside:

text is the first string of uppercase text enclosed in quotation marks, required parameters.

Text can be a text string, a formula that returns text, or a cell reference to the text string in uppercase.

For example

- Enter the text string directly into the function.

PROPER function in Excel Picture 2

- Reference to the cell containing the text string.

PROPER function in Excel Picture 3

The article described the syntax and usage of the PROPER () function in Excel, how to use the function is quite simple but effective that PROPER () brings great results. PROPER () function has a great application in practice, is widely known and used.

Hopefully the article will help you, wish you success!

David Pac

Update 19 May 2020

You should read it

May be interested

REPLACE and REPLACEB (replace part of the input text string) in Excel
the replace () and replaceb () functions are both functions that replace a part of the input text string.
The UNICHAR () and UNICODE () functions in Excel
the unichar () and unicode () functions are used for unicode charsets, you can get unicode characters from the numeric input value with unichar () and vice versa, get numeric values from the first unicode character. on with the unicode () function.
LEN () and LENB () functions in Excel
the len () function returns the number of characters in the input text string. the lenb () function returns the number of bytes used to represent characters in the input text string. the lenb function only comes to 2 bytes per character when the default language is one of the languages that supports dbcs.
RIGHT () and RIGHTB () functions in Excel
the right () function returns the result as one or more final characters in a text string based on the number of characters you give. the right () function always comes with every 1 character whether it is single byte or double byte or whatever the default language is.
SEARCH () and SEARCHB () functions in Excel
the search () function and the searchb () function are two functions that help you process strings in excel. when you need to find the starting position of a substring in a text string without case or case, you use the search () or searchb () function.
DATEDIF () function (calculate the total number of years, total months or total days from two given periods) in Excel
the datedif () function helps you calculate the total number of years, the total number of months, or the total number of days from two given periods.