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.
Example

​
CONCAT

Concatenates (combines) any number of strings into a single string. For more information, refer to the Google Sheets documentation.
Example

​
CONCATENATE

Concatenates (combines) any number of strings into a single string. Alias for CONCAT. For more information, refer to the Google Sheets documentation.
Example

​
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.
Example

​
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.
Example

​
FIND

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

​
LEN

Returns the length (number of characters) of a string. For more information, refer to the Google Sheets documentation.
Example

​
LOWER

Converts text to lowercase. For more information, refer to the Google Sheets documentation.
Example

​
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.
Example

​
PROPER

Capitalizes the first letter of each word in a text string. For more information, refer to the Google Sheets documentation.
Example

​
REPLACE

Replaces characters in a string with new text. For more information, refer to the Google Sheets documentation.
Example
Returns the specified number of characters from the end of a text string. For more information, refer to the Google Sheets documentation.
Example
Finds one text value within another, ignoring case. For more information, refer to the Google Sheets documentation.
Example
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.
Example
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.
Example

​
T

Returns string arguments as text. For more information, refer to the Google Sheets documentation.
Example

​
TEXT

Converts a number into text according to a specified format. For more information, refer to the Google Sheets documentation.
Example

​
UPPER

Converts text to uppercase. For more information, refer to the Google Sheets documentation.
Example