Administration and Executive AssistantTier 720 minintermediate

Joining Text with TEXTJOIN

Combine several contact fields into one string, skipping the ones that are blank.

What you will learn

• Use TEXTJOIN to combine several values with a delimiter between them
• Explain what the ignore_empty argument controls
• Recognise the stray double-delimiter that a blank field leaves when ignore_empty is FALSE

Excel skills

TEXTJOIN · Text Extraction

The task

Each contact has up to four email addresses, and at least one blank slot. Combine the ones that are actually filled in, in column F, separated by "; " - without a stray separator for the blank one.

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