Text Function - CONCAT

Use this function to join stuff together. It's really rather useful!

The video shows the CONCAT function in use.

The final written calculation is below:

=CONCAT(B4," ",C4)

In this formula, B4 contains the first name and C4 contains the last name.

We add a space in inverted commas to ensure there will be a space between the first and last name!