Administration and Executive AssistantTier 915 minbeginner

CONCAT vs "&" on a Range

Combine five code fragments spread across a row into one product code.

What you will learn

• Use CONCAT to flatten a multi-cell range into one string
• Explain why the "&" operator cannot take a whole range the way CONCAT can
• Recognise the #SPILL! error that results from trying

Excel skills

CONCAT · Text Extraction

The task

Each product's code is split across five columns. Combine the first product's five fragments into one code, in Summary!B3.

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