Text formatting functions
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