Copy value from 2 column to one column?
 

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

Copy value from 2 column to one column?
 

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

Copy value from 2 column to one column?
 

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


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


--
yknet
------------------------------------------------------------------------
yknet's Profile: http://www.excelforum.com/member.php...o&userid=36358
View this thread: http://www.excelforum.com/showthread...hreadid=568203