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