Administration and Executive AssistantTier 720 minintermediate

Splitting Text with TEXTSPLIT

Extract a first name from a "Surname|FirstName" field, using the right position in the split result.

What you will learn

• Use TEXTSPLIT to break a single text value into parts at a delimiter
• Explain that TEXTSPLIT returns the parts in the same order they appear in the source text
• Recognise that grabbing the wrong index still returns a plausible-looking value, just the wrong field

Excel skills

TEXTSPLIT · Text Extraction

The task

Ten employees are listed as "Surname|FirstName" in a single cell. Extract just the first name for each one, in column B.

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