# Create a new column based on two existing columns in excel

This should a very simple task, surprisingly, I am unable to find any pointers either through search or through Excel documentation. I have two Column in my excel spreadsheet:

``````A  A111  A222  B  B111  B222  C
2    11   22   3   111   222  -
5    11   22   7   111   222  -
1    11   22   5   111   222  -
``````

I want to create a third column C, which is the sum of the elements in the column A and column B as shown below:

``````C
5
12
6
``````

How do I do it in one shot so I generate an entire column ?

-
Should the value in C (second row) be 12? –  dav Jun 18 '12 at 11:23
Sorry but I don't think you've explained it well enough. If you want column C to be A+B, what's the problem with a formula (in R1C1 format as it is easier to understand): =RC1+RC4 Then copy/paste that down the rows. Make the whole table into a list and new rows added will inherit the same formula. Not quite 1 step but close. –  Julian Knight Jun 22 '12 at 8:35

http://www.wa.gov/esd/training/quickguides/xl_merge.htm

-
Welcome to superuser. We prefer that essential parts of the answers are in the answer itself. External links can go down due to link rot, or squabbling politicians. –  Journeyman Geek Oct 17 '13 at 7:03
I do understand that external links can be a pain in such forums. I just thought that the answer to this question is provided in detail with images in the form of steps in this link. But thanks, I will be careful in the future :). –  Shiva Oct 18 '13 at 11:10

You could use the ASCII code and then convert it to a character.

``````=Char(CODE(A1)+CODE(B1)-96)
``````

The minus 96 will subtract the characters before the "a".

-
I don't think he is trying to add non-numeric characters. Although this would work with letters the result of A+B=D –  wbeard52 Jun 18 '12 at 4:20
In his post it states A B with a result of C. The char allows letters and numbers. –  G Lawlor Jun 18 '12 at 4:23