Excel TEXTBEFORE and TEXTAFTER Functions (SEVEN Examples)

[@YvesAustin]

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

[@Computergaga]

Yes it is. Thank you, Yves.

[@patrickschardt7724]

What’s even better is it’s built into all the new functions where you would want to choose the beginning or ending of a reference

[@YvesAustin]

@@patrickschardt7724 Imagine if VLOOKUP() had a negative column search!! XLOOKUP() would have probably never been born!

[@patrickschardt7724]

@@YvesAustin it’s amazing how powerful VLOOKUP is and how limited it is

[@NAVEENSHARMA-k3n]

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

[@Computergaga]

Thank you so much 😀

[@IvanCortinas_ES]

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

[@Computergaga]

Thanks, Iván.

[@johnangelo9249]

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

[@Computergaga]

Glad to hear that. You're welcome.

[@patrickschardt7724]

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

[@Computergaga]

Thank you, Patrick. Yes, these are a terrific addition. I too am benefitting from them more than the introduction of TEXTSPLIT, though that is great too.

[@Luciano_mp]

Thanks Alan! 👍

[@Computergaga]

Thank you, Luciano.

[@Gunanimbuzz]

Good one.Thank you sir..!!

[@Computergaga]

You're very welcome. Thank you.

[@illiakhmaladze2071]

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,"/"),"/") 🤗

[@Computergaga]

Yes, absolutely 👍