Hello all,



Thanks in advance for your help. I have a column for first name and another for last name. I would like to make a column with full name with concatenating first name and last name. The problem though in the full name column both names are connected together, I would like a space or two! Any suggestions.

Thanks again.
Jamal

Assume that cell A1 contains the data "John", cell B1 contains the data "Smith", to have a full name in another cell, use the following formula:

=(A1 & " " & B1)

Then copy this cell to all other cells in full name column.