Hi,

Assume forename and surname in A1 and B1 then in C1 put:

=A1 & " " & B1 ' Separated by blank

or in VBA:

Range("C1").value=Range("A1").value & " " & range("B1").value

HTH

"Seaman" wrote:

I have a worksheet, names and surnames are on different columns. Any
possibility to display both of them on the 3rd column together. Thanks for
all the help
--
Peace in the world