| CONCATENATE | Concatenates two or more text strings into one string | CONCATENATE(string1, string2, ..) | CONCATENATE("Today's price is ",TEXT(6000,"$###,###.00")) | Will return "Today's price is $6,000 |
| 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 | LEFT(text/number, [num_chars]) | LEFT([Full Name],4) | When field Full Name has values such as Johny Rivers, this will return John |
| 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 | Mid (text, position, length) | MID([Full Name],0,7) | When field Full Name has values such as Johny Rivers, this will return Johny R |
| 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 | RIGHT(text/number, [num_chars]) | RIGHT([Full Name],6) | When field Full Name has values such as Johny Rivers, this will return Rivers |
| TEXT | Formats the value to the given format string | TEXT(value, format) | TEXT(6000,"$###,###.00") | Will return $6,000 |
| 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 | VALUE(value:string) | VALUE(MID”ABC-123-WEW”,5,3)) | Returns “123” as number |
