PROPER Function

From Planfix
Revision as of 13:49, 28 October 2024 by Dmitri (talk | contribs)
Jump to: navigation, search

The function PROPER () works as follows: the first letter in a text string and all first letters following non-letter characters are converted to uppercase (upper case). All other letters in the text are converted to lowercase (lower case).

Format

  • PROPER(text)

The text argument is mandatory. Text in quotes, a formula that returns text in which some letters need to be replaced with uppercase.

Examples

Formula Description Result
PROPER("this is a TITLE") Corrected case of the string This Is A Title
PROPER({{Name.Task}}) Corrected case of the string Task Name
PROPER("76BuDGet") Corrected case of the string 76Budget


Go To