Text Functions
20 functionsString manipulation, concatenation, and text formatting
CLEAN
Strips non-printable control characters from text.
CONCAT
CONCAT combines multiple text strings into a single string.
CONCATENATE
Joins text values together (legacy function).
FIND
Finds the position of text within another text string, case-sensitive.
LEFT
LEFT extracts a specified number of characters from the left side of a text string.
LEN
LEN counts the number of characters in a text string.
LENB
Returns the byte length of text.
LOWER
Makes every letter lowercase.
MID
MID extracts characters from the middle of a text string at a specified starting position.
PROPER
Title-cases each word in a string.
REPLACE
Replaces characters by position.
REPT
Repeats text a given number of times.
RIGHT
RIGHT extracts a specified number of characters from the right side of a text string.
SEARCH
Finds the position of text within another text string, case-insensitive.
SUBSTITUTE
SUBSTITUTE replaces specific text within a string with new text.
TEXT
Formats a number or date as text using a format code.
TEXTJOIN
Joins text with a delimiter, optionally skipping blanks.
TRIM
TRIM cleans up text by removing leading, trailing, and extra spaces between words.
UPPER
Makes every letter uppercase.
VALUE
Turns number-like text into an actual number.