You have a data with First and Last name columns and you want to combine both to make it a Full Name column.
=CONCATENATE comes in handy.
In column C, enter the formula =CONCATENATE (A2,” “,B2).
The ” ” allows you to have a space between contents of the 2 columns.
Similarly, you can combine whatever else you want to, for example,
Observe here that you can also input a formula inside =Concatenate, incentive of Salary * 5% has been calculated.