Course
CONCATENATE practice exercises
Five exercises, from your first full name to invoice IDs padded with zeros. Each answer is checked instantly, with a hint and the explanation if you get stuck.
Exercise 1 of 5
Join a first and last name
In C2, use CONCATENATE to join the first name in A2 and the last name in B2, with a space between them, to get Olivia Reed.
| First name | Last name | Full name |
| Olivia | Reed | |
| James | Carter | |
| Sofia | Patel | |
| Liam | Brooks | |
| Emma | Hughes | |
| Noah | Bennett |