Text Function - TEXTAFTER

A brand new function, only available on Microsoft Office 365, to help you split your text after a specific delimiter. Think Text to Columns but easier!

The video shows the TEXTAFTER function in use.

The first written calculation is below:

=TEXTAFTER(B3," ")

​Cell B3 contains the data you want to split and " " (a space character) is the delimiter you want to split by. The function will look for the first occurrence of this delimiter and display any data that appears after it. That's why we get the last name and age displayed together.

The second written calculation is:

=TEXTAFTER(B3," ",2)

We now want to split out just the age, so adding the 2 at the end of the calculation tells Excel to look for the second occurrence of the delimiter. As a result, the calculation result will be just the age.