Text

Built-in functions › Spreadsheet formulas › Text

25 functions in this category.

Function	What it does
`arraytotext`	Convert an array to a text representation.
`char`	Character with the given numeric code (Excel-compatible).
`clean`	Remove non-printable characters from a string.
`code`	Numeric character code of the first character.
`dollar`	Format a number as currency text.
`find`	Find one string within another (case-sensitive, no wildcards).
`fixed`	Format a number with a fixed number of decimal places.
`left`	First N characters of a string.
`leftb`	First N bytes of a string.
`len`	Number of characters in a string.
`lenb`	Number of bytes in a string.
`mid`	Substring starting at a given position.
`midb`	Substring by byte position and length.
`numbervalue`	Locale-aware numeric parse.
`proper`	Capitalize the first letter of each word.
`replace`	Replace a portion of a string at a specific position.
`rept`	Repeat a string a specified number of times.
`right`	Last N characters of a string.
`rightb`	Last N bytes of a string.
`search`	Find one string within another (case-insensitive).
`substitute`	Replace text by content (substring matching).
`t`	Return text values unchanged; non-text values become empty.
`text`	Format a number as text using an Excel-style format.
`textjoin`	Concatenate text values with a delimiter.
`value`	Convert a text string to a number.