# Text formatting functions

<table><thead><tr><th width="207">NAME</th><th width="510">DESCRIPTION</th><th data-hidden>SYNTAX</th><th data-hidden>EXAMPLE</th><th data-hidden>EXPLANATION</th></tr></thead><tbody><tr><td><a href="text-formatting-functions/concatenate">CONCATENATE</a></td><td>Concatenates two or more text strings into one string</td><td>CONCATENATE(string1, string2, ..)</td><td>CONCATENATE("Today's price is ",TEXT(6000,"$###,###.00"))</td><td>Will return "Today's price is $6,000</td></tr><tr><td><a href="text-formatting-functions/hyperlink">HYPERLINK</a></td><td>Returns hyperlinked text which will navigate to a given URL</td><td></td><td></td><td></td></tr><tr><td><a href="text-formatting-functions/left">LEFT</a></td><td>Extracts text from the left of the value up to the number of characters specified</td><td>LEFT(text/number, [num_chars])</td><td>LEFT([Full Name],4)</td><td>When field Full Name has values such as Johny Rivers, this will return John</td></tr><tr><td><a href="text-formatting-functions/lower">LOWER</a></td><td>Converts a text string into lowercase</td><td></td><td></td><td></td></tr><tr><td><a href="text-formatting-functions/mid">MID</a></td><td>Extracts text from the mid of a string from the position provided up to the number of characters specified in length</td><td>Mid (text, position, length)</td><td>MID([Full Name],0,7)</td><td>When field Full Name has values such as Johny Rivers, this will return Johny R</td></tr><tr><td><a href="text-formatting-functions/proper">PROPER</a></td><td>Converts the first character of a text string into uppercase</td><td></td><td></td><td></td></tr><tr><td><a href="text-formatting-functions/replace">REPLACE</a></td><td>Replaces an input text string with a given value</td><td></td><td></td><td></td></tr><tr><td><a href="text-formatting-functions/rept">REPT</a></td><td>Repeats a given text string a specified number of times</td><td></td><td></td><td></td></tr><tr><td><a href="text-formatting-functions/right">RIGHT</a></td><td>Extracts text from the right of the value up to the number of characters specified</td><td>RIGHT(text/number, [num_chars])</td><td>RIGHT([Full Name],6)</td><td>When field Full Name has values such as Johny Rivers, this will return Rivers</td></tr><tr><td><a href="text-formatting-functions/text">TEXT</a></td><td>Formats the value to the given format string</td><td>TEXT(value, format)</td><td>TEXT(6000,"$###,###.00")</td><td>Will return $6,000</td></tr><tr><td><a href="text-formatting-functions/trim">TRIM</a></td><td>Removes leading and trailing spaces</td><td></td><td></td><td></td></tr><tr><td><a href="text-formatting-functions/upper">UPPER</a></td><td>Converts a text string into uppercase</td><td></td><td></td><td></td></tr><tr><td><a href="text-formatting-functions/value">VALUE</a></td><td>Converts a text string that represents a number to a number</td><td>VALUE(value:string)</td><td>VALUE(MID”ABC-123-WEW”,5,3))</td><td>Returns “123” as number</td></tr></tbody></table>