Ravindra BagaleCourses & study guides Track your progress

Excel TEXTAFTER Function

By · Last updated:

Chala mitrano — tEXTAFTER keeps what follows the marker. Domain after @, number after the last dash.

Fictional sample data for learning. Domains and suffixes (Madurai IT + Berlin SaaS). Mixed ₹ and €.

Purpose

Return the text that sits after a given delimiter — domain after @, code after dash.

Return value

Text after the delimiter, or #N/A if missing (unless if_not_found is set).

Syntax

TEXTAFTER(text, delimiter, [instance_num], [match_mode], [match_end], [if_not_found])

Arguments

ArgumentRequired?Description
textRequiredFull text.
delimiterRequiredMarker to cut after.
instance_numOptionalWhich delimiter (default 1; negative from end).
match_modeOptional0 sensitive, 1 insensitive.
match_endOptionalAdvanced end matching.
if_not_foundOptionalFallback value.

Version

Microsoft 365 and Excel 2021. LibreOffice: usually missing — use MID+FIND fallback.

How to use — Why → What → How

Why: Madurai IT extracts domains from emails. Berlin SaaS parses ticket IDs like TCK-2026-8841 for the trailing number. instance_num -1 for tails after the last dash is the crowd-pleaser. Pair with VALUE when the tail must calculate.

What: TEXTAFTER returns everything after the chosen delimiter instance. Older Excel: MID(A2,FIND(...)+1,99). Read every argument in the table once before you type; each one changes the answer on purpose.

How — numbered steps:

  1. Type =TEXTAFTER(A2,"@").
  2. Use -1 for after the last delimiter.
  3. Set if_not_found for dirty lists.
  4. Fallback: =MID(A2,FIND("@",A2)+1,100).

Ravindra Bagale's Tip

Friends, tEXTAFTER with instance -1 is perfect for the bit after the last dash in messy IDs.

Ravindra Bagale's Tip

Friends, sleep on TEXTAFTER and rebuild example 1 tomorrow without looking. That five-minute test beats rereading the whole page.

Ravindra Bagale's Tip

Friends, after you finish TEXTAFTER, open yesterday’s real workbook and find one place this function would have saved ten minutes. That habit turns lessons into salary skills.

Download practice file: practice-textafter.xlsx (includes sheet About this data, practice sheets, and Answers).

Worked examples

1) Domain

Madurai.

Email
neha@demo.in
omar@firm.com
Formula: =TEXTAFTER(A2,"@")

Result: demo.in

What it means: Domain.

2) After last dash

Berlin tickets.

Ticket
TCK-2026-8841
TCK-2026-9001
Formula: =TEXTAFTER(A2,"-",-1)

Result: 8841

What it means: Trailing id.

3) if_not_found

No dash.

Code
PLAIN
Formula: =TEXTAFTER(A2,"-",,,,,"None")

Result: None

What it means: Fallback.

4) SKU number

Amsterdam style.

SKU
ACE-4412
Formula: =TEXTAFTER(A2,"-")

Result: 4412

What it means: Numeric part as text.

5) Fallback MID

Excel 2019.

Email
neha@demo.in
Formula: =MID(A2,FIND("@",A2)+1,100)

Result: demo.in

What it means: Same domain.

6) € SKU pair

Price sheet.

SKU€
BOL-22019.9
Formula: =TEXTAFTER(A2,"-")

Result: 2201

What it means: Suffix for sorting as text/number later.

Common errors and fixes

#N/A — Delimiter missing. Fix: if_not_found.
#NAME? — Old Excel. Fix: MID+FIND.

Notes and tips

  • Pair with VALUE if the tail must calculate.
  • Negative instance from end.
  • Fallback sheet for LibreOffice.
  • Domain reporting in Madurai and ticket parsing in Berlin are the same pattern. Teach TEXTAFTER with the MID fallback for mixed fleets of Excel versions.
  • TEXTAFTER vs RIGHT: RIGHT needs a count; TEXTAFTER needs a delimiter. vs TEXTBEFORE: opposite side.
  • Fictional sample data only — practice amounts and names are made for learning.
  • After the 10 tasks, re-read the errors table once.
  • Say the business question in plain words before you type equals.
  • Keep a scrap sheet for experiments so you do not overwrite class files.
  • Fill formulas down only after the first row looks correct.
  • When two answers look possible, write both on paper then test in Excel.
  • instance_num -1 for tails after the last dash is the crowd-pleaser. Pair with VALUE when the tail must calculate.
  • Revisit the TEXTAFTER errors table after the quiz — most classroom mistakes are listed there.
  • Build one brand-new example on a blank sheet from memory before you close the laptop.
  • If a result looks wrong, check spaces with LEN and case with exact equals before changing the formula.
  • Share one tip from this page with a classmate in Marathi or Hindi — teaching locks the idea.
  • Keep currency symbols consistent inside a single report column even when practice mixes ₹ $ £ € across examples.
  • When Excel versions differ at home and in class, write the fallback formula under the modern one in a comment cell.
  • Print the revision card for TEXTAFTER and stick it near your monitor for one week of real worksheets.
  • When helping a junior, ask them to predict the result before pressing Enter — prediction builds judgement.
  • Keep a personal notebook of the one mistake you make most often with this function; review it monthly.

In real work

Domain reporting in Madurai and ticket parsing in Berlin are the same pattern. Teach TEXTAFTER with the MID fallback for mixed fleets of Excel versions. instance_num -1 for tails after the last dash is the crowd-pleaser. Pair with VALUE when the tail must calculate. Classroom drill: write three brand-new TEXTAFTER formulas on a blank sheet using names from your own city — if you can invent them without the page open, you own the skill. Then break one formula on purpose (wrong case, wrong start, extra space) and watch the error; recovering from that break is half of interview readiness.

How it compares

TEXTAFTER vs RIGHT: RIGHT needs a count; TEXTAFTER needs a delimiter. vs TEXTBEFORE: opposite side.

Interview corner

After last delimiter?
instance_num -1.
Old Excel?
MID+FIND.
Make tail numeric?
VALUE around TEXTAFTER.

TEXTBEFORE, TEXTSPLIT, RIGHT, MID

Practice tasks (10)

  1. Task 1. Domain from neha@demo.in.
    Hint: after @.
  2. Task 2. 8841 from TCK-2026-8841.
    Hint: instance -1.
  3. Task 3. if_not_found on PLAIN.
    Hint: fallback text.
  4. Task 4. SKU suffix ACE-4412.
    Hint: after dash.
  5. Task 5. MID+FIND fallback.
    Hint: +1.
  6. Task 6. VALUE of a numeric suffix.
    Hint: nest VALUE.
  7. Task 7. Fill two emails.
    Hint: fill down.
  8. Task 8. Note version limits.
    Hint: 365/2021.
  9. Task 9. Compare to RIGHT.
    Hint: count vs delimiter.
  10. Task 10. Interview: -1 meaning?
    Hint: from end.

Quick quiz

Q1. TEXTAFTER("neha@demo.in","@") returns:
Q2. After last dash uses:
Q3. Version:
Q4. Fallback:
Q5. Missing delimiter:

Answers: Q1=demo.in, Q2=instance_num -1, Q3=365/2021, Q4=MID+FIND, Q5=#N/A or if_not_found (check after you try).

Revision card

Standalone card (no tip or photo strip). QR opens this lesson. Download the PNG and revise offline.

Revision card: TEXTAFTER
TEXTAFTER revision card