Copy value from 2 column to one column?

C

chermaine

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
 
G

Gord Dibben

In D1 enter =A1&B1

Drag/copy down as far as you need.


Gord Dibben MS Excel MVP
 
Y

yknet

chermaine said:
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
Click to expand...


Dear Thx,
I hope you can use this formula below.
=A1& "," &B1

Please note that & is just joining these A1 and A2
You can put anything you want between "". If you want space between
these 2 value A1 & B1, you should put space between "". eg. " ". you
can add what ever you want between 2 values.

Hoping it's working.
yknet
 
Top