Text Function - CONCATENATE

If you have already checked out CONCAT then this one is in the bag... it's just got a few more letters at the start, but does the same thing - joins things together!

The video shows the CONCATENATE function in use.

The final written calculation is below:

=CONCATENATE(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!