> For the complete documentation index, see [llms.txt](https://docs.inforiver.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.inforiver.com/formula-syntax/text-formatting-functions.md). # Text formatting functions Apply text formatting functions to modify and present text in a structured and readable format.

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

--- # Agent Instructions This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com. ## Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation by asking a question. Perform an HTTP GET request on the following URL with the `ask` and `goal` query parameters: ``` GET https://docs.inforiver.com/formula-syntax/text-formatting-functions.md?ask=&goal= ``` `ask` is the immediate question: it should be specific, self-contained, and written in natural language. `goal` is what the user is ultimately trying to achieve, the reason they need the answer. Sharing it helps GitBook give you a better, more relevant answer. A goal is most helpful when it describes the outcome the user wants rather than restating the question. For example, with `ask=how do I create an API token`, a goal like `automate deployments from our CI pipeline` lets GitBook tailor the answer to that use case. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.