Vicky

A1 contains Vicky

B1 contains Lastname

C1 enter =A1 & " " & B1 returns Vicky Lastname

Copy C1 and Paste Special(in place)ValueOKEsc

Delete A1 and B1


Gord Dibben Excel MVP

On Mon, 12 Dec 2005 08:22:00 -0600, Vic1978
wrote:


Hi,

how is it possible to connect two cells without loosing content of one
of those cells?

Thanks
Vicky