Home › Excel formulas › Text functions
Excel Text Functions: Full List with Examples
Text functions clean, join, split and reformat words and codes. They are the everyday tools for tidying names, IDs, addresses and imported data. Open any function for its syntax, arguments, a worked example and a free practice spreadsheet.
| Function | What it does |
|---|---|
| CONCATENATE | Joins several pieces of text into one. |
| CONCAT | The modern version of CONCATENATE, also works across ranges. |
| TEXTJOIN | Joins text together with a chosen separator between each piece. |
| LEFT | Pulls a set number of characters from the start of a text string. |
| RIGHT | Pulls a set number of characters from the end of a text string. |
| MID | Pulls characters from the middle of a text string. |
| LEN | Counts how many characters are in a text string. |
| TRIM | Removes extra spaces from text, leaving single spaces between words. |
| UPPER | Converts text to all uppercase. |
| LOWER | Converts text to all lowercase. |
| PROPER | Capitalizes the first letter of each word. |
| SUBSTITUTE | Replaces specific text within a string. |
| REPLACE | Replaces part of a text string based on position, not content. |
| FIND | Finds the position of text within another string (case-sensitive). |
| SEARCH | Like FIND, but not case-sensitive and allows wildcards. |
| TEXT | Converts a number into text, formatted the way you choose. |
| VALUE | Converts text that looks like a number into an actual number. |
| EXACT | Checks if two text strings are exactly identical, including case. |
| REPT | Repeats a piece of text a set number of times. |
| TEXTBEFORE | Returns the text that occurs before a given delimiter. |
| TEXTAFTER | Returns the text that occurs after a given delimiter. |
| TEXTSPLIT | Splits text into rows or columns using delimiters. |
| ARRAYTOTEXT | Returns an array of text values from any range, joined together. |
| VALUETOTEXT | Returns text from any single value. |
| NUMBERVALUE | Converts text to a number in a locale-independent way. |
| DOLLAR | Converts a number to text using currency format. |
| FIXED | Rounds a number and converts it to text with a fixed number of decimals. |
| T | Returns the text referred to by a value, or an empty string if it isn't text. |
| CLEAN | Removes non-printable characters from text. |
| UNICHAR | Returns the Unicode character for a given number. |
| UNICODE | Returns the Unicode number for the first character of text. |
| ASC | Converts full-width characters to half-width characters. |
| BAHTTEXT | Converts a number to Thai text with a currency suffix. |
| LEFTB | Like LEFT, but counts bytes instead of characters — for double-byte languages. |
| RIGHTB | Like RIGHT, but counts bytes instead of characters — for double-byte languages. |
| MIDB | Like MID, but counts bytes instead of characters — for double-byte languages. |
| LENB | Like LEN, but counts bytes instead of characters — for double-byte languages. |
| FINDB | Like FIND, but counts bytes instead of characters — for double-byte languages. |
| SEARCHB | Like SEARCH, but counts bytes instead of characters — for double-byte languages. |
| REPLACEB | Like REPLACE, but counts bytes instead of characters — for double-byte languages. |
| DBCS | Converts half-width characters to full-width for double-byte character sets. |
| CONCATENATE + IF | Adds a conditional prefix or suffix to a piece of text depending on whether a condition is met. |
| LEFT + FIND | Uses FIND to locate a delimiter (like a space), then LEFT to grab everything before it. |
| RIGHT + FIND | Uses FIND and LEN together to grab everything AFTER a delimiter like a space. |
| MID + FIND | Uses FIND twice to locate two delimiters, then MID to extract exactly the text between them. |
| TRIM + SUBSTITUTE | Combines SUBSTITUTE (to collapse double spaces) with TRIM (to remove leading/trailing spaces) for thoroughly cleaned text. |
| TEXTJOIN + IF (conditional join) | Combines TEXTJOIN with an IF condition to join only the values that meet a certain criteria. |
| LEN + SUBSTITUTE (count occurrences) | A classic trick: removes every occurrence of a substring, compares the length difference, to count how many times it appeared. |
| PROPER + TRIM (name cleanup) | Cleans up messy spacing AND fixes inconsistent capitalization in one step. |
| Nested SUBSTITUTE (multiple replacements) | Chains multiple SUBSTITUTE calls together to make several different text replacements in one formula. |
Practice Text functions free
Type formulas in a real spreadsheet and get instant feedback.
Start practice → Formulas cheat sheetFrequently asked questions
What are the main Excel Text functions?
Cellgrids lists 50 Excel Text functions. Popular ones include CONCATENATE, CONCAT, TEXTJOIN, LEFT, RIGHT. Each has its own page with syntax, arguments and an example.
How can I practice Excel Text functions online?
Open the free live spreadsheet on Cellgrids, type the function in a cell and check your answer. No Excel install or sign-up is needed to start.
Which Excel Text function should a beginner learn first?
Start with CONCATENATE. Joins several pieces of text into one.