Text formatting functions

Apply text formatting functions to modify and present text in a structured and readable format.

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
LEN	returns the number of characters in a text string.
.ext	specify or identify a file’s extension (like .txt or .jpg).