Skip to main content

Join first names and surnames

100%
CONCAT

Joining text is called concatenation. A full name needs the first name, one space and the surname; omitting the space produces a result that is technically joined but hard to read.

CONCAT accepts the cell values and a text literal for the separator. Because the formula refers to both name cells, correcting a spelling mistake in either source column updates the full name.

In C2:C5, use CONCAT to produce each person's first name, one space and surname.

The grid for this exercise needs a free profile.

Everything above is yours to read either way. 19 exercises stay open with no profile at all.

Adapted from Excel Beginners Practice Lab by Muhammad Auwal Abdulaziz (MIT).