Excel functions
Every Excel function (476), organized by category. Arguments in [brackets] are optional.
Formula Explainer · Paste any formula and see it broken down step by step. Free.
Try itText (48)
=ARRAYTOTEXT(array, [format])Returns an array of text values from any specified range.
=ASC(text)Changes full-width (double-byte) English letters or katakana within a character string to half-width (single-byte) characters.
=BAHTTEXT(number)Converts a number to text, using the ß (baht) currency format.
=CHAR(number)Returns the character specified by the code number.
=CLEAN(text)Removes all nonprintable characters from text.
=CODE(text)Returns a numeric code for the first character in a text string.
=CONCAT(text1, [text2], ...)Combines the text from multiple ranges and/or strings, but it doesn't provide the delimiter or IgnoreEmpty arguments.
=DBCS(text)Changes half-width (single-byte) English letters or katakana within a character string to full-width (double-byte) characters.
=DETECTLANGUAGE(text)Identifies the language of a specified text.
=DOLLAR(number, [decimals])Converts a number to text, using the $ (dollar) currency format.
=EXACT(text1, text2)Checks to see if two text values are identical.
=FIND(find_text, within_text, [start_num])Finds one text value within another (case-sensitive).
=FINDB(find_text, within_text, [start_num])Finds one text value within another (case-sensitive).
=FIXED(number, [decimals], [no_commas])Formats a number as text with a fixed number of decimals.
=LEFT(text, [num_chars])Returns the leftmost characters from a text value.
=LEFTB(text, [num_bytes])Returns the leftmost characters from a text value.
=LEN(text)Returns the number of characters in a text string.
=LENB(text)Returns the number of characters in a text string.
=LOWER(text)Converts text to lowercase.
=MID(text, start_num, num_chars)Returns a specific number of characters from a text string starting at the position you specify.
=MIDB(text, start_num, num_bytes)Returns a specific number of characters from a text string starting at the position you specify.
=NUMBERVALUE(Text, [Decimal_separator], [Group_separator ])Converts text to number in a locale-independent manner.
=PHONETIC(reference)Extracts the phonetic (furigana) characters from a text string.
=PROPER(text)Capitalizes the first letter in each word of a text value.
=REGEXEXTRACT(text, pattern, [return_mode], [case_sensitivity])Extracts strings within the provided text that matches the pattern.
=REGEXREPLACE(text, pattern, replacement, [occurrence], [case_sensitivity])Replaces strings within the provided text that matches the pattern with replacement.
=REGEXTEST(text, pattern, [case_sensitivity])Determines whether any part of text matches the pattern.
=REPLACE(old_text, start_num, num_chars, new_text)Replaces characters within text.
=REPLACEB(old_text, start_num, num_bytes, new_text)Replaces characters within text.
=REPT(text, number_times)Repeats text a given number of times.
=RIGHT(text, [num_chars])Returns the rightmost characters from a text value.
=RIGHTB(text, [num_bytes])Returns the rightmost characters from a text value.
=SEARCH(find_text, within_text, [start_num])Finds one text value within another (not case-sensitive).
=SEARCHB(find_text, within_text, [start_num])Finds one text value within another (not case-sensitive).
=SUBSTITUTE(text, old_text, new_text, [instance_num])Substitutes new text for old text in a text string.
=T(value)Converts its arguments to text.
=TEXT(value, format_text)Formats a number and converts it to text.
=TEXTAFTER(text, delimiter, [instance_num], [match_mode], [match_end], [if_not_found])Returns text that occurs after given character or string.
=TEXTBEFORE(text, delimiter, [instance_num], [match_mode], [match_end], [if_not_found])Returns text that occurs before a given character or string.
=TEXTJOIN(delimiter, ignore_empty, text1, [text2], ...)Text: Combines the text from multiple ranges and/or strings.
=TEXTSPLIT(text, col_delimiter, [row_delimiter], [ignore_empty], [match_mode], [pad_with])Splits text strings by using column and row delimiters.
=TRANSLATE(text, [source language], [target language])Translates a text from one language to another.
=TRIM(text)Removes spaces from text.
=UNICHAR(number)Returns the Unicode character that is references by the given numeric value.
=UNICODE(text)Returns the number (code point) that corresponds to the first character of the text.
=UPPER(text)Converts text to uppercase.
=VALUE(text)Converts a text argument to a number.
=VALUETOTEXT(value, [format])Returns text from any specified value.