Blake Ekelund
Excel
FP&A
Web Dev
Blog
Off the clock
Search
Ctrl K
Say hi
→
Loading...
TEXTAFTER – Excel Function | Blake Ekelund
Excel Library
›
TEXTAFTER
TEXTAFTER
Return text after a given character or delimiter.
Intermediate
— views
All
Syntax
Tutorial
Examples
Common Issues
Pro Tips
Related
Syntax
=TEXTAFTER(text, delimiter)
Example Use Cases
Extract version tag
Get text after underscore
Common Issues
TEXTAFTER returns #VALUE! when delimiter is missing
Unexpected results when multiple delimiters exist
Trailing spaces remain unless TRIM is used
Pro Tips
Wrap TEXTAFTER with TRIM to remove excess spaces
Use instance_num to target specific delimiter occurrences
Great for parsing structured filenames or codes
Related Functions in TEXT & FORMATTING
Beginner Functions
Function
Use Case
Syntax
LEN
Count the number of characters in a text string.
=LEN(text)
CLEAN
Remove non-printable characters from imported or messy text.
=CLEAN(text)
Intermediate Functions
Function
Use Case
Syntax
TEXT
Format numbers, dates, or times as text using custom formatting.
=TEXT(value, format_text)
FIND
Locate the position of a character or substring in text.
=FIND(find_text, within_text, [start_num])