Excel like a finance pro.
← The libraryPractice · 3 questions →
Text function
CONCATENATE
Joins text values; the older version of CONCAT that cannot take ranges.
CommonDifficulty 950 · CapableUsage rank #54 of 520
When to use it
The original join function. Still works everywhere, but it does not accept ranges; CONCAT and TEXTJOIN replace it.
The shape of it
- Syntax
=CONCATENATE(text1, [text2], ...)
Worked examples
Join pieces
=CONCATENATE("Blake"," ","Ekelund") → Blake Ekelund
Individual arguments.
Name formatting
=CONCATENATE(A2,", ",B2) → Ekelund, Blake
Last name, first name.
Label with number
=CONCATENATE("Total: ",TEXT(B10,"$#,##0")) → Total: $12,450
A label with a formatted number.
Worth knowing
- Use CONCAT in new work.
- The & operator is shorter for two or three pieces.
- Each argument must be a single value.
Where it goes wrong
- A range argument returns #VALUE! or only the first cell.
- Dates become serial numbers without TEXT.
Related
Learn the moves here — or let Wauvel run them on your numbers.
Meet your AI CFO →One CFO-grade Excel tip a week
A short, practical email for finance operators — functions, shortcuts, and the moves that save an afternoon. Free, unsubscribe anytime.