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 practice exercises
Joins text values together into one. Below are 1 interactive exercise that put it to work on realistic business data — you write the formula, and get told exactly what went wrong when it does not work.
Syntax
CONCAT(text1, [text2], ...)
Available from Excel 2019.
Need a refresher? Learn CONCAT — syntax, a worked example and where it goes wrong.
Practise CONCAT
Ordered from most approachable to hardest.
When CONCAT is the right tool
Joins text values together into one. It belongs to the text functions family, and it shows up constantly in real work — which is why it is worth being genuinely fluent rather than merely familiar.
Reading about a function is not the same as being able to write it. The exercises on this page exist because the gap between recognising CONCAT and producing it from memory, correctly, on data you have not seen before, only closes by doing it.
Related functions
Questions about CONCAT
How do I practise CONCAT without Excel installed?
Every exercise on this page runs in your browser. You type the CONCAT formula into a real spreadsheet grid and get told immediately whether it works — no download, no account.
What does CONCAT do?
Joins text values together into one. The syntax is CONCAT(text1, [text2], ...). The exercises below put it to work on realistic business data rather than abstract examples.
How long does it take to learn CONCAT?
Most people can write a working CONCAT formula within twenty minutes of practice. Getting it right under pressure — with edge cases, unsorted data and ranges that must survive being filled down — is what the harder exercises here are for.