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: