Excel TEXTBEFORE and TEXTAFTER Functions (SEVEN Examples)

In this video, we'll be discussing the Excel TEXTBEFORE and TEXTAFTER functions.

The Excel TEXTBEFORE function extracts characters before a specific delimiter character in a text string, while the Excel TEXTAFTER function extracts characters after a specific delimiter character.

The video will demonstrate seven examples of the the TEXTBEFORE and TEXTAFTER functions. These function are terrific and have made text manipulation much easier.

00:00 Introduction
01:15 TEXTBEFORE & TEXTAFTER syntax
01:56 TEXTBEFORE a delimiter character
02:25 TEXTBEFORE & TEXTAFTER together
03:55 Extract characters before a specific instance
06:02 Match End argument
07:11 If Not Found argument
08:07 TEXTAFTER function to return sheet name
09:56 Delimiter instance from end of string

*** Online Excel Courses ***

Connect with us!

#advancedexcelformulas #excel #excelfunctions

[YvesAustin]

The negative instance number argument is really neat! Thank you for sharing.

[johnangelo]

Thanks men, you've help me save a lot of time. Long live!!!!

[NAVEENSHARMA-kn]

Sir is talented...i wish you could have millions of subscribers...thank you so much sir...loads of love from India

[IvanCortinas_ES]

Thumbs up!!! Great tutorial. I love CELL function!! :=) Thank you Alan.

[patrickschardt]

Wonderful tutorial. Personally I like the functionality of these functions over TEXTSPLIT

[illiakhmaladze]

What If there is a string with 4 forward slashes in one of the rows? Let's say I wanna extract only a city from a string. However, the address is in a different format. How would I go about that? In some cases, the required string I wanna pull is between the first and second ", " and in others, it's between the second and third occurrence.
Sunny Street, Los Angeles, CA, 98003
Sunny Street, apt. 567, San Jose, CA, 98001
Black Street, bldg. 49 apt 166, San Franciscoko, CA, 94005

[JoseAntonioMorato]

Dear Alan.
The TEXTBEFORE and TEXTAFTER functions spill over, so you can select the entire range instead of a single cell:
=TEXTBEFORE(TEXTAFTER(A2:A6, "/"), "/") 🤗