BeginnerText Functions
Build a product code with CONCAT
Join a category prefix and an item number into a single SKU.
CONCAT
4 min10 points
CONCAT
Joins text values together into one.
Syntax
CONCAT(text1, [text2], ...)
Text Functions. Available from Excel 2019.
Practise CONCAT1 interactive exercise, free, no account needed
A worked example
=CONCAT(B2," ",C2)
Returns Marcus Bell
Joins the two values with a space between them.
Where it goes wrong
It does not insert separators for you, and it keeps empty values as gaps.
Consider instead: TEXTJOIN, when you need a separator or want blanks skipped.
What the exercises catch
Each of these is a wrong turn the practice exercises recognise and name. They are the misconceptions, not the answers.
- This spells out one SKU rather than building it from the columns, so it is wrong on every other row. Reference A2 and B2 instead of typing their contents.Build a product code with CONCAT
- You have joined the two parts but lost the hyphen, giving HW4820 rather than HW-4820. The separator has to be passed in as its own piece of text.Build a product code with CONCAT
Practise CONCAT
Knowing what a function does and being able to write it from memory are different skills. These close the gap.
All CONCAT practice exercises →