> ## Documentation Index > Fetch the complete documentation index at: https://docs.omni.co/llms.txt > Use this file to discover all available pages before exploring further. # Supported text functions > Omni supports functions typically found in most spreadsheet applications such as Google Sheets. This reference details the text functions supported by Omni. ## CHAR Returns the character specified by a number. Char values follow the ASCII value mapping. For more information, refer to the [Google Sheets documentation](https://support.google.com/docs/answer/3094123?hl=en). ``` CHAR(number) ``` **Example** ``` CHAR(10) ``` ## CONCAT Concatenates (combines) any number of strings into a single string. For more information, refer to the [Google Sheets documentation](https://support.google.com/docs/answer/3094123?hl=en). ``` CONCAT(string1, string2, ...) ``` **Example** ``` CONCAT("Hello", " ", "World") # Results in "Hello World" ``` ## CONCATENATE Concatenates (combines) any number of strings into a single string. Alias for [`CONCAT`](#concat). For more information, refer to the [Google Sheets documentation](https://support.google.com/docs/answer/3094123?hl=en). ```text theme={null} CONCATENATE(string1, string2, ...) ``` **Example** ```text theme={null} CONCATENATE("Hello", " ", "World") ``` ## CLEAN Returns text with the non-printable ASCII characters removed. Unicode characters that aren't in ASCII are not removed. For more information, refer to the [Google Sheets documentation](https://support.google.com/docs/answer/3267340?hl=en). ``` CLEAN(text) ``` **Example** ``` CLEAN("Hello"&CHAR(31)) ``` ## EXACT Tests whether two text strings are exactly the same. Returns `TRUE` if the strings match, `FALSE` otherwise. This function is case-sensitive. For more information, refer to the [Google Sheets documentation](https://support.google.com/docs/answer/3094073). ```text theme={null} EXACT(string1, string2) ``` **Example** ```text theme={null} EXACT("hello", "Hello") ``` ## FIND Returns the position of one string inside another. For more information, refer to the [Google Sheets documentation](https://support.google.com/docs/answer/3094161?hl=en). ``` FIND(find_text, within_text) ``` **Example** ``` FIND("n", "Omni") ``` **Limitations** Unlike Google Sheets or Excel, Omni's `FIND` does not accept a third argument for `start number/index`. ## LEFT Returns the specified number of characters from the start of a text string. For more information, refer to the [Google Sheets documentation](https://support.google.com/docs/answer/3094151?hl=en). ``` LEFT(text, [num_chars]) ``` **Example** ``` LEFT("Hello", 3) ``` ## LEN Returns the length (number of characters) of a string. For more information, refer to the [Google Sheets documentation](https://support.google.com/docs/answer/3094153?hl=en). ``` LEN(text) ``` **Example** ``` LEN("Hello") ``` ## LOWER Converts text to lowercase. For more information, refer to the [Google Sheets documentation](https://support.google.com/docs/answer/3094157?hl=en). ``` LOWER(text) ``` **Example** ``` LOWER("Hello") ``` ## MID Returns a specific number of characters from a text string starting at the specified position. For more information, refer to the [Google Sheets documentation](https://support.google.com/docs/answer/3094163?hl=en). ``` MID(text, start_num, num_chars) ``` **Example** ``` MID("Hello", 2, 3) ``` ## PROPER Capitalizes the first letter of each word in a text string. For more information, refer to the [Google Sheets documentation](https://support.google.com/docs/answer/3094133?hl=en). ``` PROPER(text) ``` **Example** ``` PROPER("hello world") # Results in "Hello World" ``` ## REPLACE Replaces characters in a string with new text. For more information, refer to the [Google Sheets documentation](https://support.google.com/docs/answer/3098247?hl=en). ``` REPLACE(old_text, start_num, num_chars, new_text) ``` **Example** ``` REPLACE("Hello", 2, 3, "i") ``` ## RIGHT Returns the specified number of characters from the end of a text string. For more information, refer to the [Google Sheets documentation](https://support.google.com/docs/answer/3094087?hl=en). ``` RIGHT(text, [num_chars]) ``` **Example** ``` RIGHT("Hello", 3) ``` ## SEARCH Finds one text value within another, ignoring case. For more information, refer to the [Google Sheets documentation](https://support.google.com/docs/answer/3094154). ``` SEARCH(find_text, within_text) ``` **Example** ``` SEARCH("blobs", "The happiest place on earth is Blobs R Us") ``` **Limitations** Unlike Google Sheets or Excel, Omni's `SEARCH` does not accept a third argument for `start number/index`. ## SUBSTITUTE Substitutes new text for old text in a string. For more information, refer to the [Google Sheets documentation](https://support.google.com/docs/answer/3094215). ```text theme={null} SUBSTITUTE(text, old_text, new_text) ``` **Example** ```text theme={null} SUBSTITUTE("Hello World", "World", "Omni") ``` Unlike Google Sheets or Excel, Omni's `SUBSTITUTE` does not accept a fourth argument for `instance_num`. ## TRIM Removes leading, trailing, and repeated spaces from text, leaving only single spaces between words. For more information, refer to the [Google Sheets documentation](https://support.google.com/docs/answer/3094140). ```text theme={null} TRIM(text) ``` **Example** ```text theme={null} TRIM(" Hello World ") ``` ## T Returns string arguments as text. For more information, refer to the [Google Sheets documentation](https://support.google.com/docs/answer/3094138?hl=en). ```text theme={null} T(value) ``` **Example** ```text theme={null} T(A1) T("2025-01-01") ``` ## TEXT Converts a number into text according to a specified format. For more information, refer to the [Google Sheets documentation](https://support.google.com/docs/answer/3094139?hl=en). ```text theme={null} TEXT(value, "format") ``` **Example** ```text theme={null} TEXT(1.23,"$0.00") TEXT(DATE(1969,7,20),"yyyy-MM") ``` ## UPPER Converts text to uppercase. For more information, refer to the [Google Sheets documentation](https://support.google.com/docs/answer/3094219). ```text theme={null} UPPER(text) ``` **Example** ```text theme={null} UPPER("hello") ```