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.

Data

Data

In column C, enter the formula =CONCATENATE (A2,” “,B2).

Concatenate formula

Concatenate formula

The ” ” allows you to have a space between contents of the 2 columns.

 

Similarly, you can combine whatever else you want to, for example,

Incentive email content example

Incentive email content example

Observe here that you can also input a formula inside =Concatenate, incentive of Salary * 5% has been calculated.