VOCAB 04: Text and Array Functions Flashcards

Front

Joins multiple text inputs into one text string.

Back

CONCAT

Front

Joins text items with a chosen delimiter, with the option to ignore blanks.

Back

TEXTJOIN

Front

Return a set number of characters from the start or end of text.

Back

LEFT and RIGHT

Front

Returns characters from the middle of text, starting at a set position.

Back

MID

Front

Convert text to all uppercase or lowercase.

Back

UPPER and LOWER

Front

Returns the number of characters in text.

Back

LEN

Front

Capitalizes the first letter of each word.

Back

PROPER

Front

Generates a random integer between two numbers.

Back

RANDBETWEEN

Front

Creates a sequence of numbers in rows/columns, with custom start and step.

Back

SEQUENCE

Front

Returns a sorted version of a range.

Back

SORT