Merge data from two different columns with Excel

You might have some existing data like this:

Username Identifier First name Last name
booker12 9012 Rachel Booker
grey07 2070 Laura Grey
johnson81 4081 Craig Johnson
jenkins46 9346 Mary Jenkins
smith79 5079 Jamie Smith

And now you want to create a new column, Full Name which combines first name and last name,e.g. Rachel Booker, Laura Grey, etc.

This can easily be done with Excel's Concatenate feature as shown in this video:

Another method using the & in Excel: