ExcelBanter - Formula in 2003

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Formula in 2003 (https://www.excelbanter.com/excel-worksheet-functions/131761-formula-2003-a.html)

Sean

Formula in 2003

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.

Gord Dibben

Formula in 2003

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 EditPaste Special(in place)ValuesOKEsc.

Delete columns A and B

Gord Dibben MS Excel MVP

On Wed, 21 Feb 2007 16:08:03 -0800, Sean wrote:

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.

Sean

Formula in 2003

Gord,
Thanks, it worked.

"Gord Dibben" wrote:

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 EditPaste Special(in place)ValuesOKEsc.

Delete columns A and B

Gord Dibben MS Excel MVP

On Wed, 21 Feb 2007 16:08:03 -0800, Sean wrote:

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.

All times are GMT +1. The time now is 05:28 AM.