Text Functions
Learn Excel text functions such as LEFT, RIGHT, MID, LEN, TRIM, and SUBSTITUTE with interactive lessons and exercises.
Live Score Feedback
Active Logic Validation
Industry Datasets
Text Functions Foundations
Learn how Excel text functions clean, split, combine, and standardize text values in practical worksheet workflows.
Char Function
Returns the character that matches a numeric code.
Clean Function
Removes non-printable characters from text. Useful for imported data that contains hidden control characters.
Code Function
Returns the numeric code for the first character in a text string.
Concat Function
Join text from multiple cells or entire ranges into one string. The modern replacement for CONCATENATE that finally accepts cell ranges as input.
Concatenate Function
Join two or more text strings into one. A fundamental tool for merging names, building codes, and combining labels — and the starting point for learning CONCAT and TEXTJOIN.
Dollar Function
Converts a number into currency-formatted text.
Exact Function
Compares two text strings and returns TRUE only when they match exactly, including letter case.
Find Function
Returns the position of one text string inside another. Use it when you need a case-sensitive search for a character, word, or delimiter.
Fixed Function
Rounds a number to a chosen number of decimal places and returns the result as text.
Left Function
Extracts a chosen number of characters from the start of a text string.
Leftb Function
Extracts a specified number of bytes from the start of a text string. LEFTB is mainly a legacy compatibility function for older DBCS workflows.
Len Function
Returns the number of characters in a text string, including spaces.
Lenb Function
Returns the number of bytes used by a text string. LENB is mainly a legacy compatibility function for older DBCS workflows.
Lower Function
Converts all letters in a text string to lowercase.
Mid Function
Extracts a chosen number of characters from any position inside a text string.
N Function
Converts a value to a number. Numbers stay the same, TRUE becomes 1, FALSE becomes 0, and text becomes 0.
Proper Function
Capitalizes the first letter of each word and makes the other letters lowercase.
Replace Function
Replaces part of a text string based on character position.
Rept Function
Repeats a text string a specified number of times.
Right Function
Extracts a chosen number of characters from the end of a text string.
Search Function
Returns the position of one text string inside another. SEARCH ignores case and supports wildcards.
Split Function
Extract a specific word from space-separated text using a zero-based index. Useful when you need one part of a name, label, or code.
Substitute Function
Finds specific text inside a string and replaces it with something else.
T Function
Returns the value if it is text, or an empty string if it is not.
Text Function
Converts a number or date into formatted text using a format code.
Textjoin Function
Joins multiple text strings or cell ranges into one, separated by a delimiter you choose. Automatically skips empty cells — the modern replacement for manual concatenation with &.
Trim Function
Removes leading and trailing spaces and reduces repeated internal spaces to a single space.
Unichar Function
Returns the Unicode character that matches a numeric code point.
Unicode Function
Returns the Unicode number for the first character in a text string.
Upper Function
Converts all letters in a text string to uppercase.
Value Function
Converts text that looks like a number into a real numeric value. Useful when imported numbers are stored as text.
"Mastering text manipulation is the key to cleaning and restructuring unstructured data. This path focuses on slicing, dicing, and joining strings to build robust data cleaning pipelines and automated reporting workflows."
"You will dive deep into advanced concatenation, text splitting, and transformation logic, enabling you to handle messy imports and complex string-based business requirements."