Name Surname combination
 

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

Name Surname combination
 

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

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