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"

​
CONCATENATE

Concatenates (combines) any number of strings into a single string. Alias for CONCAT. For more information, refer to the Google Sheets documentation. 
CONCATENATE(string1, string2, ...)
Example 
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. 
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. 
EXACT(string1, string2)
Example 
EXACT("hello", "Hello")

​
FIND

Returns the position of one string inside another. For more information, refer to the Google Sheets documentation. 
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. 
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)

​
PROPER

Capitalizes the first letter of each word in a text string. For more information, refer to the Google Sheets documentation. 
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. 
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)
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. 
SUBSTITUTE(text, old_text, new_text)
Example 
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. 
TRIM(text)
Example 
TRIM("  Hello   World  ")

​
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")

​
UPPER

Converts text to uppercase. For more information, refer to the Google Sheets documentation. 
UPPER(text)
Example 
UPPER("hello")