TEXTAFTER Function in Excel: Syntax, Examples and Free Practice
TEXTAFTER is an Excel Text function. Returns the text that occurs after a given delimiter.
TEXTAFTER syntax
Arguments
text: The text to work withdelimiter: The character used to separate values
When to use TEXTAFTER
TEXTAFTER is used to clean up and reshape text data pulled from other systems before reporting on it.
Practice TEXTAFTER online, free
Open the live Excel-style spreadsheet and try TEXTAFTER yourself. No Excel install or sign-up needed to start.
Practice TEXTAFTER now →Watch: TEXTAFTER in Excel
Learn more
Read the tutorial: Extract text before or after a character.
More Text functions
Frequently asked questions
What does the TEXTAFTER function do in Excel?
Returns the text that occurs after a given delimiter.
What is the syntax of TEXTAFTER in Excel?
The syntax is =TEXTAFTER(text, delimiter). text: The text to work with; delimiter: The character used to separate values.
Where can I practice TEXTAFTER online for free?
Open the free live spreadsheet on Cellgrids and try TEXTAFTER yourself. No Excel install is needed and you can start without signing up.
All Excel formulas · Cheat sheet · Excel exercises · Text functions · Excel case studies · Excel tutorials · Excel shortcuts