Text Functions

Formula Pro custom text functions including regex support and string checks.

---

CONTAINS

Checks whether a string contains another string. Case-sensitive by default.

Syntax: CONTAINS(target, searchString, [caseSensitive])

Parameter	Description
target	The string to search in
searchString	The substring to find
caseSensitive	Optional. true (default) or false

Example:

CONTAINS("Formula Pro", "Pro")

Result: true

Example:

CONTAINS("Formula Pro", "pro", false)

Result: true (case-insensitive)

Example:

CONTAINS("Formula Pro", "Excel")

Result: false

---

TEXT

Formats a number as text using Excel-style format codes. Wraps Formula.js TEXT.

Syntax: TEXT(value, format_text)

Example:

TEXT(1234.56, "0.00")

Result: "1234.56"

Example:

TEXT(DATEVALUE("2025-03-09"), "YYYY-MM-DD")

Result: "2025-03-09"

---

REGEXREPLACE

Replaces text matching a regex pattern. Supports replacement of all matches or a specific occurrence.

Syntax: REGEXREPLACE(text, pattern, replacement, [occurrence], [case_sensitivity])

Parameter	Description
text	Input text
pattern	Regex pattern (as string)
replacement	Replacement string (supports $1, $2 for capture groups)
occurrence	Optional. 0 = replace all (default); 1, 2, ... = replace Nth match only
case_sensitivity	Optional. 0 = case sensitive (default); 1 = case insensitive

Example: Replace all occurrences

REGEXREPLACE("tuttle", "t", "b")

Result: "bubble"

Example: Replace specific occurrence

REGEXREPLACE("tuttle", "t", "b", 2)

Result: "tubtle" (only second "t" replaced)

Example: Capture groups

REGEXREPLACE("2026-03-13", "(\d{4})-(\d{2})-(\d{2})", "$2/$3/$1")

Result: "03/13/2026"

Example: Case-insensitive

REGEXREPLACE("Product Vision", "vision", "plan", , 1)

Result: "Product plan"

---

REGEXTEST

Tests whether text matches a regex pattern. Returns true or false.

Syntax: REGEXTEST(text, pattern, [case_sensitivity])

Parameter	Description
text	Text to test
pattern	Regex pattern
case_sensitivity	Optional. 0 = case sensitive; 1 = case insensitive

Example:

REGEXTEST("[email protected]", "@")

Result: true

Example:

REGEXTEST("Product-123", "^\d+$")

Result: false (string is not all digits)