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
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,"/"),"/") 🤗
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.
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
Sir is sooooo talented...i wish you could have millions of subscribers...thank you so much sir...loads of love from India
Thank you so much 😀
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,"/"),"/") 🤗
Yes, absolutely 👍
The negative instance number argument is really neat! Thank you for sharing.
Yes it is. Thank you, Yves.
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
@@patrickschardt7724 Imagine if VLOOKUP() had a negative column search!! XLOOKUP() would have probably never been born!
@@YvesAustin it’s amazing how powerful VLOOKUP is and how limited it is
Thumbs up!!! Great tutorial. I love CELL function!! :=) Thank you Alan.
Thanks, Iván.
Wonderful tutorial. Personally I like the functionality of these functions over TEXTSPLIT
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.
Thanks men, you've help me save a lot of time. Long live!!!!
Glad to hear that. You're welcome.
Good one.Thank you sir..!!
You're very welcome. Thank you.
Thanks Alan! 👍
Thank you, Luciano.
TOP.....TOP, thanks
Thank you 😊