Text formatting functions

NAME
DESCRIPTION

CONCATENATE

Concatenates two or more text strings into one string

HYPERLINK

Returns hyperlinked text which will navigate to a given URL

LEFT

Extracts text from the left of the value up to the number of characters specified

LOWER

Converts a text string into lowercase

MID

Extracts text from the mid of a string from the position provided up to the number of characters specified in length

PROPER

Converts the first character of a text string into uppercase

REPLACE

Replaces an input text string with a given value

REPT

Repeats a given text string a specified number of times

RIGHT

Extracts text from the right of the value up to the number of characters specified

TEXT

Formats the value to the given format string

TRIM

Removes leading and trailing spaces

UPPER

Converts a text string into uppercase

VALUE

Converts a text string that represents a number to a number

This section is being updated. Some formulas and functions may not be currently available in the visuals or the docs. We appreciate your understanding and patience as we work to provide comprehensive information about these formulas and functions.

Last updated