# 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>CONCATENATE</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>HYPERLINK</td><td>Returns hyperlinked text which will navigate to a given URL</td><td></td><td></td><td></td></tr><tr><td>LEFT</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>LOWER</td><td>Converts a text string into lowercase</td><td></td><td></td><td></td></tr><tr><td>MID</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>PROPER</td><td>Converts the first character of a text string into uppercase</td><td></td><td></td><td></td></tr><tr><td>REPLACE</td><td>Replaces an input text string with a given value</td><td></td><td></td><td></td></tr><tr><td>REPT</td><td>Repeats a given text string a specified number of times</td><td></td><td></td><td></td></tr><tr><td>RIGHT</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>TEXT</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>TRIM</td><td>Removes leading and trailing spaces</td><td></td><td></td><td></td></tr><tr><td>UPPER</td><td>Converts a text string into uppercase</td><td></td><td></td><td></td></tr><tr><td>VALUE</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>