Formula in 2003

S

Sean

I have three columns; A, B and C.
A and B contain numbers.
I need to add values in A and B and put them in to column C and then delete
column A and B.
 
G

Gord Dibben

Sean

In C1 enter =A1+B1 or =A1&B1 if by "add" you mean join together.

Double-click on C1 fill handle to copy down.

Select column C and Edit>Paste Special(in place)>Values>OK>Esc.

Delete columns A and B


Gord Dibben MS Excel MVP
 
S

Sean

Gord,
Thanks, it worked.

Gord Dibben said:
Sean

In C1 enter =A1+B1 or =A1&B1 if by "add" you mean join together.

Double-click on C1 fill handle to copy down.

Select column C and Edit>Paste Special(in place)>Values>OK>Esc.

Delete columns A and B


Gord Dibben MS Excel MVP
Click to expand...
 
Top