Join text with & and CONCAT
Exercise 1 of 3
In C2, join the first and last name with a space between them, using &.
About this lesson
Join text from several cells with the & operator or CONCAT, for example a first and a last name.
In this lesson
- In
C2, join the first and last name with a space between them, using&. - In
C3, write Ben's name as "Okafor, Ben" withCONCAT. - In
D2, build the code from the prefix and the number, with a dash between them.
Use the arrow keys to move between cells; each cell is read out as you go. Type a formula and press Enter. The sheet is also available as a table below.
fx
Type in C2 and press Enter to check.