Cellwise · Working with text

TEXTBEFORE, TEXTAFTER and TEXTSPLIT

Split text at a marker in one step.

You can split any delimited text with functions built for it.

This lesson has 4 steps of hands-on practice in a live spreadsheet. Every formula you write is also tested on data you haven’t seen, so you know it really works.