Text Functions¶

String Extraction¶

Function	Syntax	Example	Result
LEFT	`LEFT(text, num_chars)`	`=LEFT("Hello", 3)`	`Hel`
RIGHT	`RIGHT(text, num_chars)`	`=RIGHT("Hello", 2)`	`lo`
MID	`MID(text, start, num_chars)`	`=MID("Hello", 2, 3)`	`ell`
LEN	`LEN(text)`	`=LEN("Hello")`	5

Function	Syntax	Example	Result
UPPER	`UPPER(text)`	`=UPPER("hello")`	`HELLO`
LOWER	`LOWER(text)`	`=LOWER("HELLO")`	`hello`
PROPER	`PROPER(text)`	`=PROPER("john doe")`	`John Doe`

Function	Syntax	Example	Result
CONCATENATE	`CONCATENATE(text1, ...)`	`=CONCATENATE("A", "B")`	`AB`
TEXTJOIN	`TEXTJOIN(delim, ignore_empty, text1, ...)`	`=TEXTJOIN(", ", TRUE, A1:A3)`	`a, b, c`
TRIM	`TRIM(text)`	`=TRIM(" hi ")`	`hi`
CLEAN	`CLEAN(text)`	`=CLEAN(A1)`	Text with non-printable chars removed
REPT	`REPT(text, times)`	`=REPT("ab", 3)`	`ababab`

Function	Syntax	Example	Result
FIND	`FIND(find_text, within, [start])`	`=FIND("l", "Hello")`	3
SEARCH	`SEARCH(find_text, within, [start])`	`=SEARCH("L", "Hello")`	3 (case-insensitive)
SUBSTITUTE	`SUBSTITUTE(text, old, new, [instance])`	`=SUBSTITUTE("aaa", "a", "b", 1)`	`baa`
REPLACE	`REPLACE(text, start, num_chars, new)`	`=REPLACE("Hello", 1, 2, "A")`	`Allo`
EXACT	`EXACT(text1, text2)`	`=EXACT("ABC", "abc")`	FALSE

Function	Syntax	Example	Result
TEXT	`TEXT(value, format)`	`=TEXT(1234.5, "#,##0.00")`	`1,234.50`
VALUE	`VALUE(text)`	`=VALUE("123")`	123
NUMBERVALUE	`NUMBERVALUE(text)`	`=NUMBERVALUE("1,234.5")`	1234.5
T	`T(value)`	`=T("hi")`	`hi` (returns text or empty)
CHAR	`CHAR(number)`	`=CHAR(65)`	`A`
CODE	`CODE(text)`	`=CODE("A")`	65