I'm compiling a cheat sheet of formulas for my office workers to use. When I get to the Text functions, I can find examples of how to do just about everything except extract text before/after a particular string. I've found a few formulas for doing it after a symbol, but they don't work when it comes to a string.
For example, say I have 15 paragraphs that all begin with "Yo mamma's so ugly that..." and I want to extract whatever follows after "that". Or, say I have 1000 lines of text formatted
and I want to extract everything after the 4th character string (HERD in this example), or before the 4th string. Is there a way to do that in a formula that can adapted to any situation?
Your help in augmenting my knowledge is already greatly appreciated.
Thanks,
John
Bookmarks