CONTAINS

Formula Explanation

Detects if a text contains a specific string, returns true/false

Formula Syntax

In result column, input: contains(column_code / "text", "search string")

• The parameters can be column codes, e.g. AA1

Usage Examples

1. Check if text in column BZ2 contains "today", return true/false in BZ3

BZ3 = contains(BZ2, "today")

2. Check if "happy-today" contains "today", return true/false in CA2

CA2 = contains("happy-today", "today")

✉️ Ask Tablize