Text Excel Functions

Manipulate and format text strings

Most used text formulas

  • Join cells → [TEXTJOIN](/functions/textjoin/), [CONCAT](/functions/concat/), or [CONCATENATE](/functions/concatenate/)
  • Extract substrings → [LEFT](/functions/left/), [RIGHT](/functions/right/), [MID](/functions/mid/)
  • Find & replace in formulas → [FIND](/functions/find/), [SEARCH](/functions/search/), [SUBSTITUTE](/functions/substitute/)
  • Clean spaces → [TRIM](/functions/trim/) and [CLEAN](/functions/clean/)
  • Change case → [UPPER](/functions/upper/), [LOWER](/functions/lower/), [PROPER](/functions/proper/)

Before VLOOKUP or XLOOKUP

  • Hidden spaces cause #N/A → run [TRIM](/functions/trim/) on keys first
  • Text vs number → [VALUE](/functions/value/) or Text to Columns
  • Lookup errors → [#N/A guide](/errors/na/) and [VLOOKUP #N/A fix](/problems/vlookup-returning-na/)

Functions in this category

  • CONCAT: Joins two or more text strings into one string.
  • LEFT: Returns the specified number of characters from the start of a text string.
  • RIGHT: Returns the specified number of characters from the end of a text string.
  • MID: Returns a specific number of characters from a text string, starting at a specified position.
  • LEN: Returns the number of characters in a text string.
  • FIND: Finds one text string within another and returns the starting position (case-sensitive).
  • SEARCH: Finds one text string within another and returns the starting position (case-insensitive, supports wildcards).
  • SUBSTITUTE: Replaces occurrences of old text with new text in a string.
  • TRIM: Removes extra spaces from text, leaving only single spaces between words.
  • UPPER: Converts text to uppercase.
  • LOWER: Converts text to lowercase.
  • PROPER: Capitalizes the first letter of each word in a text string.
  • TEXT: Converts a value to text in a specified number format.
  • TEXTJOIN: Joins text from multiple ranges with a delimiter, with option to ignore empty cells.
  • CHAR: Returns the character specified by a number (ASCII or Unicode code).
  • CODE: Returns the numeric code for the first character in a text string.
  • CLEAN: Removes all non-printable characters from text.
  • EXACT: Compares two text strings and returns TRUE if they are exactly the same (case-sensitive).
  • FIXED: Formats a number as text with a fixed number of decimals.
  • REPT: Repeats text a specified number of times.
  • DOLLAR: Converts a number to text in currency format.
  • TEXTAFTER: Returns text that occurs after a specified delimiter.
  • TEXTBEFORE: Returns text that occurs before a specified delimiter.
  • TEXTSPLIT: Splits text into rows or columns using delimiters.
  • UNICHAR: Returns the Unicode character for a given number.
  • UNICODE: Returns the Unicode code point for the first character of a text string.
  • NUMBERVALUE: Converts text to a number in a locale-independent way.
  • ASC: Changes full-width (double-byte) characters to half-width (single-byte) characters.
  • ARRAYTOTEXT: Returns an array of text values from any specified range.
  • BAHTTEXT: Converts a number to Thai text and adds the suffix Baht.
  • CONCATENATE: Joins several text strings into one string.
  • VALUETOTEXT: Returns text from any specified value.
  • T: Returns the text referred to by value.
  • PHONETIC: Extracts the phonetic (furigana) characters from a text string.
  • JIS: Changes half-width (single-byte) characters to full-width (double-byte) characters.
  • LEFTB: Returns the leftmost characters from a text value based on bytes.
  • RIGHTB: Returns the rightmost characters from a text value based on bytes.
  • MIDB: Returns a specific number of characters from a text string based on bytes.
  • LENB: Returns the number of bytes used to represent the characters in a text string.
  • DBCS: Converts half-width (single-byte) characters to full-width (double-byte) characters in a text string.
  • VALUE: Converts a text string that represents a number to a number.