# text functions

Join, split, clean, search and format strings.

63 functions.

- [ASC](https://deepcalc.com/docs/functions/asc.md): converts full-width characters to half-width
- [BAHTTEXT](https://deepcalc.com/docs/functions/bahttext.md): spells a number as thai baht and satang
- [CHAR](https://deepcalc.com/docs/functions/char.md): returns the character for a character-set code
- [CLEAN](https://deepcalc.com/docs/functions/clean.md): removes non-printable characters
- [CODE](https://deepcalc.com/docs/functions/code.md): numeric code of the first character
- [CONCAT](https://deepcalc.com/docs/functions/concat.md): joins multiple text strings into one
- [CONCATENATE](https://deepcalc.com/docs/functions/concatenate.md): joins several text strings into one
- [CONTAINS](https://deepcalc.com/docs/functions/contains.md): checks if text contains substring
- [DBCS](https://deepcalc.com/docs/functions/dbcs.md): converts half-width characters to full-width
- [DOLLAR](https://deepcalc.com/docs/functions/dollar.md): formats a number as currency text
- [ENDSWITH](https://deepcalc.com/docs/functions/endswith.md): checks if text ends with suffix
- [EXACT](https://deepcalc.com/docs/functions/exact.md): checks if two text strings are identical
- [FIND](https://deepcalc.com/docs/functions/find.md): finds text within another text, case-sensitive
- [FINDB](https://deepcalc.com/docs/functions/findb.md): finds text within text by bytes, case-sensitive
- [FIXED](https://deepcalc.com/docs/functions/fixed.md): formats a number as text with a fixed number of decimals
- [JIS](https://deepcalc.com/docs/functions/jis.md): converts half-width characters to full-width (alias of DBCS)
- [JOIN](https://deepcalc.com/docs/functions/join.md): joins values with delimiter
- [LEFT](https://deepcalc.com/docs/functions/left.md): returns leftmost characters from text
- [LEFTB](https://deepcalc.com/docs/functions/leftb.md): returns leftmost bytes from text
- [LEN](https://deepcalc.com/docs/functions/len.md): returns number of characters in text
- [LENB](https://deepcalc.com/docs/functions/lenb.md): returns number of bytes in text
- [LOWER](https://deepcalc.com/docs/functions/lower.md): converts text to lowercase
- [MID](https://deepcalc.com/docs/functions/mid.md): returns characters from middle of text
- [MIDB](https://deepcalc.com/docs/functions/midb.md): returns bytes from middle of text
- [NUMBERVALUE](https://deepcalc.com/docs/functions/numbervalue.md): converts text to a number, locale-independent
- [PROPER](https://deepcalc.com/docs/functions/proper.md): capitalizes the first letter of each word
- [REGEXEXTRACT](https://deepcalc.com/docs/functions/regexextract.md): extracts the first regex match
- [REGEXMATCH](https://deepcalc.com/docs/functions/regexmatch.md): true when text matches a regular expression
- [REGEXREPLACE](https://deepcalc.com/docs/functions/regexreplace.md): replaces regex matches with new text
- [REGEXTEST](https://deepcalc.com/docs/functions/regextest.md): whether text matches a regular expression
- [REPLACE](https://deepcalc.com/docs/functions/replace.md): replaces characters by position
- [REPLACEB](https://deepcalc.com/docs/functions/replaceb.md): replaces characters by byte position
- [REPT](https://deepcalc.com/docs/functions/rept.md): repeats text a given number of times
- [RIGHT](https://deepcalc.com/docs/functions/right.md): returns rightmost characters from text
- [RIGHTB](https://deepcalc.com/docs/functions/rightb.md): returns rightmost bytes from text
- [SEARCH](https://deepcalc.com/docs/functions/search.md): finds text within another text, case-insensitive
- [SEARCHB](https://deepcalc.com/docs/functions/searchb.md): finds text within text by bytes, case-insensitive
- [SPLIT](https://deepcalc.com/docs/functions/split.md): splits text by delimiter into multiple cells
- [STARTSWITH](https://deepcalc.com/docs/functions/startswith.md): checks if text starts with prefix
- [SUBSTITUTE](https://deepcalc.com/docs/functions/substitute.md): replaces old text with new text
- [T](https://deepcalc.com/docs/functions/t.md): returns text if value is text, else empty
- [TEXT](https://deepcalc.com/docs/functions/text.md): formats number as text with given format
- [TEXTAFTER](https://deepcalc.com/docs/functions/textafter.md): returns text after a delimiter
- [TEXTBEFORE](https://deepcalc.com/docs/functions/textbefore.md): returns text before a delimiter
- [TEXTCAPITALIZE](https://deepcalc.com/docs/functions/textcapitalize.md): capitalizes first letter of text
- [TEXTCENTER](https://deepcalc.com/docs/functions/textcenter.md): centers text with padding to reach specified length
- [TEXTCOMPARE](https://deepcalc.com/docs/functions/textcompare.md): compares two texts and returns -1, 0, or 1
- [TEXTCOUNT](https://deepcalc.com/docs/functions/textcount.md): counts occurrences of substring in text
- [TEXTINDENT](https://deepcalc.com/docs/functions/textindent.md): indents text with specified number of characters
- [TEXTJOIN](https://deepcalc.com/docs/functions/textjoin.md): joins text with delimiter, ignoring blanks
- [TEXTPADLEFT](https://deepcalc.com/docs/functions/textpadleft.md): pads text on the left with character to reach specified length
- [TEXTPADRIGHT](https://deepcalc.com/docs/functions/textpadright.md): pads text on the right with character to reach specified length
- [TEXTREVERSE](https://deepcalc.com/docs/functions/textreverse.md): reverses text
- [TEXTSPLIT](https://deepcalc.com/docs/functions/textsplit.md): splits text by delimiters into an array
- [TEXTSWAPCASE](https://deepcalc.com/docs/functions/textswapcase.md): swaps uppercase and lowercase letters
- [TEXTTITLE](https://deepcalc.com/docs/functions/texttitle.md): converts text to title case
- [TEXTWRAP](https://deepcalc.com/docs/functions/textwrap.md): wraps text at specified width
- [TRIM](https://deepcalc.com/docs/functions/trim.md): removes extra spaces from text
- [UNICHAR](https://deepcalc.com/docs/functions/unichar.md): returns the character for a unicode code point
- [UNICODE](https://deepcalc.com/docs/functions/unicode.md): returns unicode number of first character
- [UPPER](https://deepcalc.com/docs/functions/upper.md): converts text to uppercase
- [VALUE](https://deepcalc.com/docs/functions/value.md): converts text string to a number
- [VALUETOTEXT](https://deepcalc.com/docs/functions/valuetotext.md): returns text from any value type

## navigate

- [function index](https://deepcalc.com/docs/functions.md)
- [error values](https://deepcalc.com/docs/errors.md) · [concepts](https://deepcalc.com/docs/concepts.md) · [limits](https://deepcalc.com/docs/limits.md)

source: https://deepcalc.com/docs/functions/text-functions