Excellency

View Original

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!” 

PROPER function converting a text string so that the first character of each word is uppercase, while the rest are lowercase

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)