Administration and Executive AssistantTier 425 minintermediate

TEXTBEFORE and TEXTAFTER for One-Step Splitting

Split text around a delimiter directly, without calculating a character position first.

What you will learn

• Use TEXTBEFORE and TEXTAFTER to split text on a delimiter in one step
• Compare this to the FIND + MID approach and identify where the older method is more fragile
• Handle a delimiter that might not appear in every row

Excel skills

TEXTBEFORE, TEXTAFTER, TEXTSPLIT · Modern Text Functions

The task

Split every email on the Contacts tab into its local part (before the @) and its domain (after the @) on the Cleaned tab. Do it in one step per part - no calculating a character position first.

You work in a real spreadsheet in your browser, and your answer is checked against hidden traps the moment you submit.

Try this lesson free