Get Fop Lodge Contact Request Form

In the first formula, concatenation is done with an ampersand character (&). The second formula relies on the corresponding function (the word "concatenate" is just another way to say "join together"). Please pay attention that in both cases, you insert a space character (" ") in-between to separate the name parts.

Additionally, if you want to add a space or any other character between the first and last name, you can simply include it within the quotation marks in the formula. For example, if you want to add a comma and space between the first and last name, the formula would be "=CONCATENATE(First Name, ", ", Last Name)".

To combine first and last names, use the CONCATENATE function or the ampersand (&) operator.

0:52 4:41 How to Combine First and Last Name in Excel - YouTube YouTube Start of suggested clip End of suggested clip Different items into a single cell. For now Excel will offer only two fields. Text 1 and text 2 hereMoreDifferent items into a single cell. For now Excel will offer only two fields. Text 1 and text 2 here. You can enter the data you need to combine.

Whenever you need to merge first and last names together in one cell, the fastest way is to concatenate two cells by using the ampersand operator (&) or the CONCATENATE function as shown in the below examples.

These formula will look like =B2&” , “&A2. This formula is basically the same one mentioned above, but with names in reverse order and separated by a comma and space. Step 3: The other formula is =CONCATENATE(last_name_cell, “, “,first name). This formula will be shown as =CONCATENATE(B2, “, “,A2).

Combine data using the CONCAT function Select the cell where you want to put the combined data. Type =CONCAT(. Select the cell you want to combine first. Use commas to separate the cells you are combining and use quotation marks to add spaces, commas, or other text. Close the formula with a parenthesis and press Enter.