REGEXREPLACE Function in Excel: Find and Replace With Patterns
REGEXREPLACE replaces text matching a pattern — strip every non-digit, collapse repeated spaces, mask numbers.
Read article →Text
Excel Text functions explained with syntax, examples and common mistakes.
📊
← Excel
Text
Excel Text functions explained with syntax, examples and common mistakes.
📄 48 articles⬇️ 36 with practice files🕒 Updated 13 Oct 2026
🎓 Start here: Excel for India Course → 🎓 Start here: Excel Course: Beginner → Expert → 🎓 Start here: Bank Statement Automation →NUMBERVALUE Function in Excel: Convert Text Numbers With Any Separators
NUMBERVALUE Function in Excel: Convert Text Numbers With Any Separators
NUMBERVALUE converts text to a number using separators you specify — essential for European-style “1.234,56” exports.
Read article →VALUE Function in Excel: Convert Text to a Number
VALUE Function in Excel: Convert Text to a Number
VALUE turns text that looks like a number into a real number, so SUM and lookups work.
Read article →T Function in Excel: Keep Text, Blank Out Numbers
T Function in Excel: Keep Text, Blank Out Numbers
T returns text unchanged and anything else as an empty string. Rarely needed alone, but tidy for mixed columns.
Read article →ARRAYTOTEXT Function in Excel: A Whole Range as One Text
ARRAYTOTEXT Function in Excel: A Whole Range as One Text
ARRAYTOTEXT turns a range into a single text string. Strict mode gives array-constant syntax you can paste into another formula.
Read article →EXACT Function in Excel: Case-Sensitive Comparison
EXACT Function in Excel: Case-Sensitive Comparison
EXACT compares two texts including upper/lower case. A normal =A2=B2 ignores case.
Read article →REGEXEXTRACT Function in Excel: Pull Text That Matches a Pattern
REGEXEXTRACT Function in Excel: Pull Text That Matches a Pattern
REGEXEXTRACT returns the part of text that matches a pattern — invoice numbers, phone numbers, amounts buried in narration.
Read article →SEARCH Function in Excel: Position of Text (Any Case, Wildcards)
SEARCH Function in Excel: Position of Text (Any Case, Wildcards)
SEARCH works like FIND but ignores case and accepts wildcards (? and *). With ISNUMBER it becomes a “contains” test.
Read article →TEXTAFTER Function in Excel: Text After a Delimiter
TEXTAFTER Function in Excel: Text After a Delimiter
TEXTAFTER returns the text that follows a delimiter — domains from emails, surnames, file extensions.
Read article →VALUETOTEXT Function in Excel: Any Value as Text
VALUETOTEXT Function in Excel: Any Value as Text
VALUETOTEXT converts any value to text; strict mode adds quotes around text so you can see stray spaces.
Read article →TEXTBEFORE Function in Excel: Text Before a Delimiter
TEXTBEFORE Function in Excel: Text Before a Delimiter
TEXTBEFORE returns everything before a delimiter; TEXTAFTER everything after. They replace most LEFT/FIND and MID/FIND combinations.
Read article →TEXTSPLIT Function in Excel: Split Text Into Cells
TEXTSPLIT Function in Excel: Split Text Into Cells
TEXTSPLIT splits text by a delimiter into columns and/or rows — a formula version of Text to Columns that updates automatically.
Read article →