Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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 ?

share|improve this question
    
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

2 Answers 2

I think you might find this link helpful.

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

share|improve this answer
4  
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".

share|improve this answer
    
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

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.