How to use TEXTAFTER in Google Sheets & Excel guide

1. Manual ways to extract text after a delimiter

1.1 Using TEXTAFTER in Excel

For modern Excel (Microsoft 365 / Excel 2021+), TEXTAFTER is the native way to grab everything after a delimiter.

Basic pattern:
=TEXTAFTER(text, delimiter, [instance_num], [match_mode], [match_end], [if_not_found])

Example: Get the domain from an email

1. Suppose A2 contains alex@simular.ai.
2. In B2 enter:
   =TEXTAFTER(A2, "@")
3. Result: simular.ai.

Example: Get everything after the last dash

1. A2: SKU-2025-Q1-US.
2. To get just US, use a negative instance:
   =TEXTAFTER(A2, "-", -1).
3. To get Q1-US (after the second dash from the left):
   =TEXTAFTER(A2, "-", 2).

You can tune behavior:

• match_mode: 0 for case‑sensitive, 1 for case‑insensitive.
• if_not_found: e.g. "" to avoid #N/A.

Full reference: Microsoft’s official doc at https://support.microsoft.com/en-us/office/textafter-function-c8db2546-5b51-416a-9690-c7e6722e90b4

1.2 Using classic functions in Excel (when TEXTAFTER isn’t available)

If you’re on older Excel, you can emulate TEXTAFTER.

Get text after the first comma:

1. A2: John Doe, CEO, Simular.
2. In B2:
   =MID(A2, FIND(",", A2) + 1, LEN(A2))
3. This finds the comma, jumps one character, and returns the rest.

Get text after the last space:

1. A2: Maria Lopez Growth Lead.
2. Find last space:
   =FIND("♦",SUBSTITUTE(A2," ","♦",LEN(A2)-LEN(SUBSTITUTE(A2," ",""))))
3. Then wrap in MID:
   =MID(A2, that_formula + 1, LEN(A2))

This is clunky but works where TEXTAFTER is missing.

1.3 Approximating TEXTAFTER in Google Sheets

Google Sheets doesn’t yet have TEXTAFTER, but you can replicate it.

Using SPLIT for simple cases:

1. A2: name@company.com.
2. In B2:
   =INDEX(SPLIT(A2, "@"), 1, 2)
3. SPLIT creates {"name","company.com"} and INDEX picks the second value.

Using REGEXEXTRACT for patterns:

1. To get everything after the first dash:
   A2: AB-123-XYZ.
2. In B2:
   =REGEXEXTRACT(A2, "-(.*)")
3. This returns 123-XYZ.

Docs:

• SPLIT: https://support.google.com/docs/answer/3094136
• REGEXEXTRACT: https://support.google.com/docs/answer/3098242

2. No-code automation methods

Once you know the formulas, the next step is to stop doing the same clicks every Monday.

2.1 Google Sheets: Automate with macros + simple triggers

Scenario: Weekly CSV export from your CRM that needs domain names extracted from email addresses.

1. Import one sample CSV into a sheet Raw_Leads.
2. In another sheet Clean_Leads, set up formulas:
   • A2: reference original email: =Raw_Leads!A2.
   • B2: domain:
     =INDEX(SPLIT(Raw_Leads!A2, "@"), 1, 2).
3. Fill these formulas down for a typical data range (e.g. 5,000 rows).
4. Use Extensions → Macros → Record macro and:
   • Clear Raw_Leads.
   • Import the latest CSV.
   • Let Sheets recalc automatically.
5. Save the macro and, optionally, connect it to a simple App Script trigger to run on a schedule.

Result: Drop in a new file, click a macro (or wait for the trigger), and all the “TEXTAFTER-like” parsing runs for you.

2.2 Excel: Power Query for repeatable text splitting

Power Query can industrialize text extraction without code.

Example: Clean a messy product code column

1. In Excel, select your data range and choose Data → From Table/Range.
2. In Power Query, select the column (e.g. Product_Code: BRAND-SKU-2025-Q1).
3. Use Transform → Split Column → By Delimiter.
4. Choose delimiter -, select Right-most delimiter to mimic "after last dash" behavior when needed.
5. Name the new column (e.g. Quarter).
6. Click Close & Load.

Next time the file updates, just hit Refresh—Power Query reruns the whole pipeline.

Docs:

• Power Query intro: https://support.microsoft.com/en-us/office/getting-started-with-query-editor-power-query-7104fbee-9e62-4cb9-a02e-5bfb1a6c536a

2.3 Zapier / Make: Chain TEXTAFTER-style logic across tools

For marketers and agencies, your "text after" needs rarely live in a single sheet.

Example: Parse UTM parameters from links in a form tool and log them in Sheets

1. Trigger: Form submission in Typeform or HubSpot.
2. Action: Send the row to Google Sheets via Zapier or Make.
3. In a destination column, use:
   =REGEXEXTRACT(A2, "utm_campaign=([^&]+)")
4. The automation writes raw URLs; Sheets formulas act like TEXTAFTER to keep campaign names and sources clean.

Now your analytics dashboard always has ready-to-use fields with no manual parsing.

3. Scaling with AI agents (Simular) at desktop level

At some point, even no-code tools hit limits: odd one-off files, legacy Excel models, or teams that refuse to touch formulas. This is where an AI computer agent like Simular becomes your ops teammate.

3.1 Pattern: Let the agent operate Excel directly

Simular Pro is designed to behave like a power user:

1. You describe the workflow in natural language:
   • "Open this Excel file, find the column with emails, create a new column 'Domain', apply TEXTAFTER or an equivalent, fill down, save as a new file."
2. The agent opens Excel on your desktop, navigates the UI, types the formula =TEXTAFTER(A2, "@") (or a legacy MID/FIND combo), drags it down, and saves.
3. Every click is logged, so you can inspect and adjust.

Pros:

• Works with any Excel version and messy UI-only workflows.
• No need to teach your team formulas.
• Ideal for agencies handling dozens of client templates.

Cons:

• Slightly more setup upfront (defining the workflow once).
• Best on stable, repeatable processes.

Learn more about Simular Pro’s desktop automation at https://www.simular.ai/simular-pro

3.2 Pattern: End-to-end web → Sheets → Excel automation

For sales or marketing teams that live in online tools:

1. Simular agent logs into your CRM or ad platform.
2. Exports CSVs, opens Google Sheets, pastes data, and inserts formulas using SPLIT or REGEXEXTRACT.
3. Optionally downloads a summarized Excel report where TEXTAFTER is used to clean final fields.

Now, the entire “extract text after X” routine—from web app export to cleaned spreadsheet—is hands-off. You trigger it via a webhook or a simple command.

Pros:

• Fully cross-app: browser, Sheets, Excel.
• Great for recurring weekly or daily reporting.

Cons:

• Requires clear definition of edge cases (missing delimiters, bad rows) so the agent knows how to handle errors.

By starting with manual formulas, layering in no-code tools, and finally letting an AI agent run the whole play, you move from “I know how TEXTAFTER works” to “My spreadsheet text cleanup runs itself while I close deals.”