Name Surname combination
Suggest you add a trim function to remove any spurious spaces at end,
beginning and double spaces in text strings.
=trim(A1 & " " & B1)
Range("C1").value= trim(Range("A1").value & " " & range("B1").value)
--
Cheers
Nigel
"Toppers" wrote in message
...
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
|