Skip to main content

​
CHAR

Returns the character specified by a number. Char values follow the ASCII value mapping. For more information, refer to the Google Sheets documentation. 
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. 
CONCAT(string1, string2, ...)
Example 
CONCAT("Hello", " ", "World")       # Results in "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. 
CLEAN(text)
Example 
CONCAT("Hello"&CHAR(31))

​
FIND

Returns the position of one string inside another. For more information, refer to the Google Sheets documentation. 
FIND(find_text, within_text, [start_num])
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. 
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. 
LEN(text)
Example 
LEN("Hello")

​
LOWER

Converts text to lowercase. For more information, refer to the Google Sheets documentation. 
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. 
MID(text, start_num, num_chars)
Example 
MID("Hello", 2, 3)

​
REPLACE

Replaces characters in a string with new text. For more information, refer to the Google Sheets documentation. 
REPLACE(old_text, start_num, num_chars, new_text)
Example 
REPLACE("Hello", 2, 3, "i")
Returns the specified number of characters from the end of a text string. For more information, refer to the Google Sheets documentation. 
RIGHT(text, [num_chars])
Example 
RIGHT("Hello", 3)
Finds one text value within another, ignoring case. For more information, refer to the Google Sheets documentation. 
SEARCH(find_text, within_text, [start_num])
Example 
SEARCH("blobs","The happiest place on earth is Blobs R Us")SEARCH("blob","Hello, Blob", 6)

​
T

Returns string arguments as text. For more information, refer to the Google Sheets documentation. 
T(value)
Example 
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. 
TEXT(value, "format")
Example 
TEXT(1.23,"$0.00")TEXT(DATE(1969,7,20),"yyyy-MM")