ExcelHeroThe CONCAT function
Joins text from several cells or values.
In German Excel: TEXTKETTE
How to write it
=CONCAT(text1, [text2], …)- text1
- Text, a cell or a range.
💡 The & sign does the same: =A2&" "&B2.
Try it
Make the full name again, this time with CONCAT.
A
B
C
1
First
Last
Full
2
Grace
Hopper
=CONCAT(first, " ", last).