Formualizer Docs
ReferenceFunctionsText Functions

PROPER

PROPER: Capitalizes the first letter of each alphanumeric word.

Summary

Capitalizes the first letter of each alphanumeric word.

Remarks

  • Word boundaries are reset by non-alphanumeric characters.
  • Internal letters in each word are lowercased.
  • Non-text inputs are coerced to text.
  • Errors are propagated unchanged.

Examples

Title case simple phrase
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
Hello World
Hyphen-separated words
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
North-East Region

FAQ

How are word boundaries determined?

Any non-alphanumeric character starts a new word boundary for capitalization.

Runtime metadata

Category

Text

Signature

PROPER(arg1: Any)

Arity

min 1, max 1

Arguments

arg1

Any · Scalar

Caps

PURE

Source

crates/formualizer-eval/src/builtins/text/trim_case_concat.rs

MID

MID: Returns a substring starting at a 1-based position.

REPLACE

Replaces part of a text string by position.

On this page

SummaryRemarksExamplesRelated functionsFAQHow are word boundaries determined?Runtime metadata