# text functions

join, split, clean, search and format strings.

63 functions.

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

## navigate

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

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