Syntax, a live playground, a measured joining gallery, the range and number-format traps, and a sourced error library: joining text items in order.
Joins up to 255 text items into one string in the order given. Takes individual items, not ranges; numbers become text.
CONCATENATE joins up to 255 text items into one string, in the order you list them. Numbers become text. Every row was measured live in HyperFormula. Click any row to load it.
| Expression | Result | Why |
|---|---|---|
| =CONCATENATE(A2,A3) | ExcelFormula | Join two cells with no separator |
| =CONCATENATE(A2," ",A3) | Excel Formula | Add a space between the parts |
| =CONCATENATE(A2,"-",B2) | Excel-101 | Mix text and a number |
| =CONCATENATE("a","b","c") | abc | Join literal strings |
| =CONCATENATE(A5," ",A2) | Lab Excel | Order is exactly as listed |
| =CONCATENATE(B2,C2) | 1013 | Numbers are joined as text |
| =CONCATENATE(A2,"/",A3,"/",A4) | Excel/Formula/Lookup | Build a path from parts |
| =A2&A3 | ExcelFormula | The & operator does the same job |
| Expression | Result | Why |
|---|---|---|
| =A2&" "&A3 | Excel Formula | The & operator joins with less typing |
| =CONCATENATE(A2) | Excel | A single item is returned as text |
Edit the table or type any formula — the engine evaluates instantly. Load a preset to see CONCATENATE join cells, add separators, mix numbers, and match the & operator.
8 failure patterns mined from actual user reports on Reddit, Stack Overflow and Super User — each with the authentic symptom, root cause, a fix, and a runnable formula. Not textbook theory.
CONCATENATE is available across modern Excel, Google Sheets and LibreOffice. It is legacy; CONCAT and TEXTJOIN (Excel 2019+) are the modern replacements.
| Platform | Support | Notes | Gotcha |
|---|
CONCATENATE is one piece. The full course walks the toolkit end to end with live, measured examples.