# Text Functions

## Content

DsExcel.NET provides the following lookup and reference functions, listed alphabetically.

| Function | Description |
| -------- | ----------- |
| [ARRAYTOTEXT](/document-solutions/dot-net-excel-api/docs/online/formula-reference/text-functions/arraytotext) | This function returns an array of text values from any specified range. It passes text values unchanged, and converts non-text values to text. |
| [ASC](/document-solutions/dot-net-excel-api/docs/online/formula-reference/text-functions/asc) | This function converts full-width (double-byte) characters to half-width (single-byte) characters. |
| [BAHTTEXT](/document-solutions/dot-net-excel-api/docs/online/formula-reference/text-functions/bahttext) | This function converts a number to Thai text and adds a suffix of "Baht" |
| [CHAR](/document-solutions/dot-net-excel-api/docs/online/formula-reference/text-functions/char) | This function returns the character specified by a number. |
| [CLEAN](/document-solutions/dot-net-excel-api/docs/online/formula-reference/text-functions/clean) | This function removes all non-printable characters from text. |
| [CODE](/document-solutions/dot-net-excel-api/docs/online/formula-reference/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](/document-solutions/dot-net-excel-api/docs/online/formula-reference/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](/document-solutions/dot-net-excel-api/docs/online/formula-reference/text-functions/concatenate) | This function combines multiple text strings or numbers into one text string. |
| [DBCS](/document-solutions/dot-net-excel-api/docs/online/formula-reference/text-functions/dbcs) | This function converts half-width (single-byte) characters to full-width (double-byte) characters. |
| [DOLLAR](/document-solutions/dot-net-excel-api/docs/online/formula-reference/text-functions/dollar) | This function converts a number to text using currency format, with the decimals rounded to the specified place. |
| [EXACT](/document-solutions/dot-net-excel-api/docs/online/formula-reference/text-functions/exact) | This function returns true if two strings are the same; otherwise, false. |
| [FIND](/document-solutions/dot-net-excel-api/docs/online/formula-reference/text-functions/find) | This function finds one text value within another and returns the text value’s position in the text you searched. |
| [FINDB](/document-solutions/dot-net-excel-api/docs/online/formula-reference/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](/document-solutions/dot-net-excel-api/docs/online/formula-reference/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](/document-solutions/dot-net-excel-api/docs/online/formula-reference/text-functions/jis) | This function converts half-width (single-byte) characters to full-width (double-byte) characters. Supported in Japanese and German language packages only. |
| [LEFT](/document-solutions/dot-net-excel-api/docs/online/formula-reference/text-functions/left) | This function returns the specified leftmost characters from a text value, and based on the number of characters you specify. |
| [LEFTB](/document-solutions/dot-net-excel-api/docs/online/formula-reference/text-functions/leftb) | This function returns the specified leftmost characters from a text value, and based on the number of bytes you specify. |
| [LEN](/document-solutions/dot-net-excel-api/docs/online/formula-reference/text-functions/len) | This function returns the length of the number of characters in a text string. |
| [LENB](/document-solutions/dot-net-excel-api/docs/online/formula-reference/text-functions/lenb) | This function returns the length of the number of bytes in a text string. |
| [LOWER](/document-solutions/dot-net-excel-api/docs/online/formula-reference/text-functions/lower) | This function converts text to lower case letters. |
| [MID](/document-solutions/dot-net-excel-api/docs/online/formula-reference/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](/document-solutions/dot-net-excel-api/docs/online/formula-reference/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. |
| [NUMBERVALUE](/document-solutions/dot-net-excel-api/docs/online/formula-reference/text-functions/numbervalue) | This function converts text to number in a locale-independent manner. |
| [PROPER](/document-solutions/dot-net-excel-api/docs/online/formula-reference/text-functions/proper) | This function capitalizes the first letter in each word of a text string. |
| [REPLACE](/document-solutions/dot-net-excel-api/docs/online/formula-reference/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](/document-solutions/dot-net-excel-api/docs/online/formula-reference/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](/document-solutions/dot-net-excel-api/docs/online/formula-reference/text-functions/rept) | This function repeats text a specified number of times. |
| [RIGHT](/document-solutions/dot-net-excel-api/docs/online/formula-reference/text-functions/right) | This function returns the specified rightmost characters from a text value, and based on the number of characters you specify. |
| [RIGHTB](/document-solutions/dot-net-excel-api/docs/online/formula-reference/text-functions/rightb) | This function returns the specified rightmost characters from a text value, and based on the number of bytes you specify. |
| [SEARCH](/document-solutions/dot-net-excel-api/docs/online/formula-reference/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](/document-solutions/dot-net-excel-api/docs/online/formula-reference/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](/document-solutions/dot-net-excel-api/docs/online/formula-reference/text-functions/substitute) | This function substitutes a new string for specified characters in an existing string. |
| [T](/document-solutions/dot-net-excel-api/docs/online/formula-reference/text-functions/t) | This function returns the text in a specified cell. |
| [TEXT](/document-solutions/dot-net-excel-api/docs/online/formula-reference/text-functions/text) | This function formats a number and converts it to text. |
| [TEXTAFTER](/document-solutions/dot-net-excel-api/docs/online/formula-reference/text-functions/textafter) | This function returns text after delimiting characters. |
| [TEXTBEFORE](/document-solutions/dot-net-excel-api/docs/online/formula-reference/text-functions/textbefore) | This function returns text before delimiting characters. |
| [TEXTSPLIT](/document-solutions/dot-net-excel-api/docs/online/formula-reference/text-functions/textsplit) | This function splits text into rows or columns using delimiters. |
| [TEXTJOIN](/document-solutions/dot-net-excel-api/docs/online/formula-reference/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. |
| [TRIM](/document-solutions/dot-net-excel-api/docs/online/formula-reference/text-functions/trim) | This function removes extra spaces from a string and leaves single spaces between words. |
| [UNICHAR](/document-solutions/dot-net-excel-api/docs/online/formula-reference/text-functions/unichar) | This function returns the Unicode character of a given numeric reference. |
| [UNICODE](/document-solutions/dot-net-excel-api/docs/online/formula-reference/text-functions/unicode) | This function returns the number corresponding to the first character of the text. |
| [UPPER](/document-solutions/dot-net-excel-api/docs/online/formula-reference/text-functions/upper) | This function converts text to uppercase letters. |
| [VALUE](/document-solutions/dot-net-excel-api/docs/online/formula-reference/text-functions/value) | This function converts a text string that is a number to a numeric value. |
| [VALUETOTEXT](/document-solutions/dot-net-excel-api/docs/online/formula-reference/text-functions/valuetotext) | This function returns text from any specified value. It passes text values unchanged, and converts non-text values to text. |