How To Combine First and Last Name In Excel

 Cell&" "&Cell

This formula is used to concatenate two cells in Excel with a space in between them.

For example, if we have text in cell A1 as "Hello" and in cell B1 as "World", then by applying the formula =A1&" "&B1 in cell C1, we will get the output as "Hello World" (with a space in between "Hello" and "World").

The "&" symbol is used for concatenation and the quotation marks with a space inside them " " are used to insert a space between the contents of the two cells.