Text functions
All 35 functions in this category
CONCATCONCAT joins two or more text strings into one continuous string, automatically coercing numbers and dates to text without a delimiter.CONCATENATECONCATENATE joins several text strings into one continuous string, in the order the arguments are supplied, and returns it as a single text value.TEXTJOINTEXTJOIN merges multiple text strings or ranges into one string, using a chosen delimiter and optional ignoring of empty cells.LEFTLEFT returns the leftmost characters from a text string, optionally limited by a specified number of characters.RIGHTRIGHT returns the specified number of characters from the end of a text string, defaulting to one character if omitted.MIDMID extracts a specified number of characters from a text string, starting at a given position, and returns the resulting substring.LENLEN returns the number of characters in a text string, counting letters, numbers, spaces and punctuation, and returns 0 for an empty cell.FINDFIND returns the numeric position of a substring within a text string, counting from a specified start point and respecting case sensitivity.SEARCHSEARCH returns the numeric position of a substring within a text string, counting from a specified start point and ignoring case.SUBSTITUTESUBSTITUTE returns a new text string where specified characters or substrings are replaced, optionally limiting the change to a particular occurrence.REPLACEREPLACE returns a new text string where a specified number of characters in the original text are substituted with new characters.TRIMTRIM removes all leading and trailing spaces from a text string, returning a clean version without extra blanks.CLEANCLEAN removes all non-printing characters (ASCII 0–31) from a text string, returning a clean version suitable for further processing or display.UPPERUPPER converts any supplied text to all capital letters, returning a string of the same length with every alphabetic character in uppercase.LOWERLOWER converts any supplied text to all-lowercase characters, returning a string or an array of strings matching the input shape.PROPERPROPER converts a text string to title case, capitalising the first letter of each word while making all other letters lower-case.TEXTTEXT converts a numeric, date, or time value into a formatted text string based on a custom format pattern you supply.VALUEVALUE converts a text string that looks like a number, currency, or date into the underlying numeric value Excel or Sheets can use in calculations.NUMBERVALUENUMBERVALUE converts a text string that represents a number—using any decimal or group separator—into a true numeric value that can be used in calculations.TEXTBEFORETEXTBEFORE returns the substring before a given delimiter, letting you pick which occurrence and supply your own value when the delimiter is absent.TEXTAFTERTEXTAFTER returns the substring that appears after a specified delimiter within a text string, optionally selecting which occurrence to use.TEXTSPLITTEXTSPLIT breaks a text string into a dynamic array by column and optional row delimiters, returning each piece in its own cell.REPTREPT repeats a text string a specified number of times, returning the concatenated result as a single text value, useful for visual bars or padding.EXACTEXACT returns TRUE if two text strings are exactly the same, including case, and FALSE otherwise, making it ideal for case-sensitive comparisons.CHARCHAR returns the character represented by a given numeric code point, letting you embed symbols like line breaks or currency signs directly in formulas.CODEThe CODE function returns the numeric Unicode (ASCII) value of the first character in a given text string, useful for character-level analysis in spreadsheets.UNICHARUNICHAR returns the Unicode character that corresponds to a given decimal code point, letting you insert symbols directly in Excel or Google Sheets.UNICODEUNICODE returns the decimal Unicode code point of the first character in a text string, letting you work with character codes in spreadsheets.DOLLARDOLLAR formats a number as text with a dollar sign, optional decimals, rounding and thousand separators, ideal for showing list prices in real-estate sheets.FIXEDFIXED returns a number as text, rounded to a specified number of decimal places and optionally displayed without thousands separators.TThe T function returns the text of a value, passing through text unchanged and yielding an empty string for non-text inputs.ASCASC converts full-width (double-byte) characters in a text string to their single-byte ASCII equivalents, returning a normalized plain-text result.REGEXTESTREGEXTEST checks whether a text string matches a regular-expression pattern and returns TRUE or FALSE, optionally respecting case sensitivity.REGEXEXTRACTREGEXEXTRACT returns the portion of a text string that matches a regular expression, optionally respecting case and returning multiple matches.REGEXREPLACEREGEXREPLACE returns a new text string where parts matching a regular expression are replaced with a specified replacement.