In D1 enter =A1&B1

Drag/copy down as far as you need.


Gord Dibben MS Excel MVP

On 3 Aug 2006 20:36:43 -0700, "chermaine" wrote:

I hope someone could help me to solve this.
Actually I m trying to copy value from say (A1 &B1) to D1
i.e. A1 shows 1
B1 shows ,2

desiired D1 shows 1,2

Is there a way to do this in a min? Coz i got lots of cells to copy if
no macro helps

Thx
chermaine