Join first and last name with &
Step 1 of 3
The & operator joins texts into one, the way + adds numbers. =A2&B2 puts the two names right next to each other.
Click Continue when you're ready.
Already know it? Type the formula straight into C2.
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | First name | Last name | Full name | |||
| 2 | Anna | Berg | ||||
| 3 | ||||||
| 4 | ||||||
| 5 | ||||||
| 6 | ||||||
| 7 | ||||||
| 8 |
Need help?
Why this works
& glues texts together exactly as they are, so A2&B2 gives "AnnaBerg". The space is a text of its own, " ", so it needs quotes and an & on each side: A2&" "&B2.
Common mistake: Leaving out the space. & adds nothing between the parts, so you get "AnnaBerg".
The answer
- C2
=A2&" "&B2
=A2&" "&B2 joins the two cells with a space between them. =CONCAT(A2," ",B2) does the same.
+10 points