Find text: FIND, SEARCH, TEXTBEFORE, TEXTAFTER

FIND and SEARCH tell you where a piece of text is (SEARCH ignores capitals). TEXTBEFORE and TEXTAFTER cut at a separator, like the @ in an email.

5 exercises in this lesson are part of ExcelHero Pro.