The PROPER function

The PROPER function is a text function which formats text strings with uppercase letters for the first letter of each word in the string.

This is the format of the PROPER function:

=PROPER(INPUT STRING)

Here is an example of the PROPER function:

=PROPER(“hello, and welcome to excellency!” = “Hello, And Welcome To Excellency!”

This function is valuable when creating consistent title text for reports or documentation. Often comprised of multiple independent strings, being able to give a clean presentation by wrapping your resulting string in a PROPER function leaves a big impact on the end users.

An example of a functional implementation of this would be when treated exported information from a secondary system, or when treating scraped web data, and needing to prepare it for an analysis. While numeric data can be easier to resolve by creating a standard format to search and index text with, as well as the removal of non-printable characters, makes text analysis easier by removing the unintended side effects of poor formatting across various language types.

=PROPER(SCRAPED TEXT FIELD)