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.

Text (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.