more_vert

Supported Excel Functions

Text functions

Syntax

text1 Required.
The first item to join. The item can be a text value, or a number.

text2,... Optional.
Additional text items to join.

Concatenates the text strings.

This is the Adaptive Calculation Engine implementation of the Excel CONCATENATE function.

Syntax

CONCAT(text1, [text2], ...)

text1 Required.
The first item to join. The item can be a text value, a number or a table array name.

text2,... Optional.
Additional text items to join.

Concatenates the text from multiple compute field ranges and/or strings.

This is the Adaptive Calculation Engine implementation of the Excel CONCAT function.

Syntax

EXACT(text1, text2)

text1 Required.
The first text string.

text2 Required.
The second text string.

Compares two text strings and returns true if they are exactly the same, false otherwise. EXACT is case-sensitive but ignores formatting differences.

This is the Adaptive Calculation Engine implementation of the Excel EXACT function.

Syntax

FIND(find_text, within_text, start_num)

find_text Required.
The text you want to find.

within_text Required.
The text containing the text you want to find.

start_num Optional.
Specifies the character at which to start the search. The first character in the within_text is the character number 1. If you omit the start_num, it is assumed to be 1.

Locates one text string within a second text string, and returns the number of the starting position of the first text string from the first character of the second text string.

This is the Adaptive Calculation Engine implementation of the Excel FIND function.

Syntax

LEFT(text1, num_chars)

text Required.
The text string containing the characters you want to extract.

num_chars Required.
Specifies the number of characters you want LEFT to extract.

Returns the first character or characters in a text string, based on the number of characters you specify.

This is the Adaptive Calculation Engine implementation of the Excel LEFT function.

Syntax

TRIM(text)
text Required.
The text string containing the characters you want to extract.

Removes all spaces (only space characters) from text except for single spaces between words.

This is the Adaptive Calculation Engine implementation of theExcel TRIM function.

Syntax

MID(text, start_num, num_char)

text Required.
The text string containing the characters you want to extract.

start_num Requiredl.
The position of the first character you want to extract in a text string. The first character in a text string has the start_num 1, and so on.

num_chars Required.
Specifies the number of characters you want MID to return from text.

Returns a specific number of characters from a text string, starting at the position you specify, based on the number of characters you specify.

This is the Adaptive Calculation Engine implementation of the Excel MID function.

Syntax

LEN(text)

text Required.
The text string.

Returns the number of characters in a text string.

This is the Adaptive Calculation Engine implementation of the Excel LEN function.

Syntax

TEXTJOIN(delimiter, ignore_empty, text1, [text2], ...)

delimiter     Required.
A text value or a number. If a number is supplied, it will be treated as text.

ignore_empty     Required.
If true, ignore empty fields or empty table array elements.

text1     Required.
The first item to join. The item can be a text value, a number or a table array name.

text2,...     Optional.
Additional text items to join.

Concatenates the text from multiple compute field ranges and/or strings, and includes a delimiter you specify between each text value that will be concatenated.

This is the Adaptive Calculation Engine implementation of the Excel TEXTJOIN function.

Syntax

SUBSTITUTE(text, old_text, new_text, start_num)

find_text Required.
The text for which you want to substitute characters.

old_text Required.
The text you want to replace.

new_text Required.
The text you want to replace old_text with.

instance_num    Optional.
Optional. Specifies which occurrence of old_text you want to replace with new_text. If you specify instance_num, only that instance of old_text is replaced. Otherwise, every occurrence of old_text in text is changed to new_text.

Substitutes old_text for new_text in a text string.

This is the Adaptive Calculation Engine implementation of the Excel SUBSTITUTE function.