# Text Functions

## Content

Spread provides the following lookup and reference functions, listed alphabetically.

| Function | Description |
| -------- | ----------- |
| [ASC-function](/spreadjs/docs/v16/formulareference/FormulaFunctions/text-functions/ASC-function) | This function converts full-width (double-byte) characters to half-width (single-byte) characters. |
| [BAHTTEXT](/spreadjs/docs/v16/formulareference/FormulaFunctions/text-functions/BAHTTEXT) | This function converts a number to Thai text and adds a suffix of "Baht" |
| [CHAR](/spreadjs/docs/v16/formulareference/FormulaFunctions/text-functions/CHAR) | This function returns the character specified by a number. |
| [CLEAN](/spreadjs/docs/v16/formulareference/FormulaFunctions/text-functions/CLEAN) | This function removes all non-printable characters from text. |
| [CODE](/spreadjs/docs/v16/formulareference/FormulaFunctions/text-functions/CODE) | This function returns a numeric code to represent the first character in a text string. The returned code corresponds to the Windows character set (ANSI). |
| [CONCAT](/spreadjs/docs/v16/formulareference/FormulaFunctions/text-functions/CONCAT) | This function combines multiple text strings or numbers into one text string, the function will stay available for compatibility with "CONCATENATE" function. |
| [CONCATENATE](/spreadjs/docs/v16/formulareference/FormulaFunctions/text-functions/CONCATENATE) | This function combines multiple text strings or numbers into one text string. |
| [DBCS](/spreadjs/docs/v16/formulareference/FormulaFunctions/text-functions/dbcs-function) | This function converts half-width (single-byte) characters to full-width (double-byte) characters. |
| [DOLLAR](/spreadjs/docs/v16/formulareference/FormulaFunctions/text-functions/DOLLAR) | This function converts a number to text using currency format, with the decimals rounded to the specified place. |
| [FIND](/spreadjs/docs/v16/formulareference/FormulaFunctions/text-functions/FIND) | This function finds one text value within another and returns the text value’s position in the text you searched. |
| [FINDB](/spreadjs/docs/v16/formulareference/FormulaFunctions/text-functions/FINDB) | This function finds one text value within another and returns the text value's position in the text you searched, and counts each double-byte characte as 2 when set DBCS as the default language. |
| [FIXED](/spreadjs/docs/v16/formulareference/FormulaFunctions/text-functions/FIXED) | This function rounds a number to the specified number of decimal places, formats the number in decimal format using a period and commas (if so specified), and returns the result as text. |
| [JIS](/spreadjs/docs/v16/formulareference/FormulaFunctions/text-functions/jis-function) | This function converts half-width (single-byte) characters to full-width (double-byte) characters. Supported in Japanese and German language packages only. |
| [LEFT](/spreadjs/docs/v16/formulareference/FormulaFunctions/text-functions/LEFT) | This function returns the specified leftmost characters from a text value, and based on the number of characters you specify. |
| [LEFTB](/spreadjs/docs/v16/formulareference/FormulaFunctions/text-functions/LEFTB) | This function returns the specified leftmost characters from a text value, and based on the number of bytes you specify. |
| [LEN](/spreadjs/docs/v16/formulareference/FormulaFunctions/text-functions/LEN) | This function returns the length of the number of characters in a text string. |
| [LENB](/spreadjs/docs/v16/formulareference/FormulaFunctions/text-functions/LENB) | This function returns the length of the number of bytes in a text string. |
| [LOWER](/spreadjs/docs/v16/formulareference/FormulaFunctions/text-functions/LOWER) | This function converts text to lower case letters. |
| [MID](/spreadjs/docs/v16/formulareference/FormulaFunctions/text-functions/MID) | This function returns the requested number of characters from a text string starting at the position you specify, and based on the number of characters you specify. |
| [MIDB](/spreadjs/docs/v16/formulareference/FormulaFunctions/text-functions/MIDB) | This function returns the requested number of characters from a text string starting at the position you specify, and based on the number of bytes you specify. |
| [PROPER](/spreadjs/docs/v16/formulareference/FormulaFunctions/text-functions/PROPER) | This function capitalizes the first letter in each word of a text string. |
| [REPLACE](/spreadjs/docs/v16/formulareference/FormulaFunctions/text-functions/REPLACE) | This function replaces part of a text string with a different text string, based on the number of characters you specify. |
| [REPLACEB](/spreadjs/docs/v16/formulareference/FormulaFunctions/text-functions/REPLACEB) | This function replaces part of a text string with a different text string, based on the number of bytes you specify. |
| [REPT](/spreadjs/docs/v16/formulareference/FormulaFunctions/text-functions/REPT) | This function repeats text a specified number of times. |
| [RIGHT](/spreadjs/docs/v16/formulareference/FormulaFunctions/text-functions/RIGHT) | This function returns the specified rightmost characters from a text value, and based on the number of characters you specify. |
| [RIGHTB](/spreadjs/docs/v16/formulareference/FormulaFunctions/text-functions/RIGHTB) | This function returns the specified rightmost characters from a text value, and based on the number of bytes you specify. |
| [SEARCH](/spreadjs/docs/v16/formulareference/FormulaFunctions/text-functions/SEARCH) | This function finds one text string in another text string and returns the index of the starting position of the found text. |
| [SEARCHB](/spreadjs/docs/v16/formulareference/FormulaFunctions/text-functions/SEARCHB) | This function finds one text string in another text string and returns the index of the starting position of the found text, and counts each double-byte characte as 2 when set DBCS as the default language. |
| [SUBSTITUTE](/spreadjs/docs/v16/formulareference/FormulaFunctions/text-functions/SUBSTITUTE) | This function substitutes a new string for specified characters in an existing string. |
| [T](/spreadjs/docs/v16/formulareference/FormulaFunctions/text-functions/T) | This function returns the text in a specified cell. |
| [TEXT](/spreadjs/docs/v16/formulareference/FormulaFunctions/text-functions/TEXT) | This function formats a number and converts it to text. |
| [TEXTAFTER](/spreadjs/docs/v16/formulareference/FormulaFunctions/text-functions/textafter) | This function returns text after delimiting characters. |
| [TEXTBEFORE](/spreadjs/docs/v16/formulareference/FormulaFunctions/text-functions/text) | This function returns text before delimiting characters. |
| [TEXTJOIN](/spreadjs/docs/v16/formulareference/FormulaFunctions/text-functions/TEXTJOIN) | This function combines multiple ranges and/or strings into one text, and the text includes a delimiter you specify between each text value. |
| [TEXTSPLIT](/spreadjs/docs/v16/formulareference/FormulaFunctions/text-functions/textsplit) | This function splits text into rows or columns using delimiters. |
| [TRIM](/spreadjs/docs/v16/formulareference/FormulaFunctions/text-functions/TRIM) | This function removes extra spaces from a string and leaves single spaces between words. |
| [UNICHAR](/spreadjs/docs/v16/formulareference/FormulaFunctions/text-functions/UNICHAR) | This function returns the Unicode character of a given numeric reference. |
| [UNICODE](/spreadjs/docs/v16/formulareference/FormulaFunctions/text-functions/UNICODE) | This function returns the number corresponding to the first character of the text. |
| [UPPER](/spreadjs/docs/v16/formulareference/FormulaFunctions/text-functions/UPPER) | This function converts text to uppercase letters. |
| [VALUE](/spreadjs/docs/v16/formulareference/FormulaFunctions/text-functions/VALUE) | This function converts a text string that is a number to a numeric value. |