---
title: The TEXTAFTER Function | Full Stack Modeller
description: Learn how to use Excel’s TEXTAFTER function. The TEXTAFTER function is a key part of a modeller’s Excel toolkit.
---

[Blog ](https://www.fullstackmodeller.com/blog)

# [The TEXTAFTER Function | Full Stack Modeller](https://www.fullstackmodeller.com/blog/how-to-use-the-textafter-function)

 Written by [Myles Arnott](https://www.fullstackmodeller.com/blog/author/myles-arnott) | Sep 27, 2022, 2:38:00 PM

*Returns text from a cell that occurs after a given delimiter*

## What does Excel's TEXTAFTER function do?

The TEXTAFTERfunction is one of Excel's text functions.

TEXTAFTER returns the text from a text string that occurs after a given delimiter (character or string).

### Here's a simple example

Let's take a look at a simple example of the TEXTAFTER function.

We would like to return the text that comes after the first space.

#### =TEXTAFTER(A1," ")

#### What does that mean in plain English?

Return the text that comes after the first space.

#### How do I write a formula using the TEXTAFTER function?

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

 

text – The text that you want to extract text from

delimiter – The character that you want to extract text after

[instance_num] – The instance of the delimiter you want to extract after. Defaul is 1. Use a negative number to start from the end.

[match_mode]– Case sensitive delimiter. TRUE = yes (default) , FALSE = no

[match_end]– Treat the end of the text string as the delimiter.

[if_not_found] – What to return if the delimiter provided is not found. By default, #N/A is returned

#### What to consider when using the TEXTAFTER function in your  model

- The TEXTAFTER function was introduced in 2019, so be aware of compatibility issues for users of previous Excel versions.
- Use a negative number in the instance_num arguement to start from the end.

 

Read more about the TEXTAFTER function on the Microsoft support page [here](https://support.microsoft.com/en-us/office/textbefore-function-d099c28a-dba8-448e-ac6c-f086d0fa1b29).

[View full post](https://www.fullstackmodeller.com/blog/how-to-use-the-textafter-function)

```json
{
  "@context" : "http://schema.org",
  "@type" : "BlogPosting",
  "author" : {
    "@type" : "Person",
    "name" : "Myles Arnott"
  },
  "dateModified" : "2024-09-21T16:10:30.989Z",
  "datePublished" : "2022-09-27T14:38:00Z",
  "headline" : "How to use Excel's TEXTAFTER Function",
  "image" : {
    "@type" : "ImageObject",
    "height" : 1260,
    "url" : "https://www.fullstackmodeller.com/hubfs/How%20to%20use%20Excels%20TEXTAFTER%20Function.png",
    "width" : 2240
  },
  "mainEntityOfPage" : "https://www.fullstackmodeller.com/blog/how-to-use-the-textafter-function",
  "publisher" : {
    "@type" : "Organization",
    "logo" : {
      "@type" : "ImageObject",
      "height" : 60,
      "url" : "/hs/hsstatic/content_shared_assets/static-1.4092/img/default-amp-logo.png",
      "width" : 60
    },
    "name" : "Blog"
  }
}
```