πŸ”₯ 0

TextJoin text

The & sign glues text together: =A2&" "&B2. CONCAT and TEXTJOIN do the same with functions.

Make the full name: first name, a space, last name.

A
B
C
1
First
Last
Full
2
Ada
Lovelace
3