How to make one column be the result of an equation between two

  • Thread starter Thread starter dcnguyen
  • Start date Start date
D

dcnguyen

I have a blank column which I want to fill with the results of a
concatenation between two other columns...could someone give me the
general steps on how to do this (doesn't have to be concatenation
operation, could also be a sum between values of columns, for example).
 
Hi

Assuming the columns with values are A and B and the blank column to
receive the results is C.

For concatenation, in C1
=A1&B1 or with a space between =A1&" "&B1

For addition
=A1+B1
 
Thanks for the response...two things...

I'm typing that in the cell (=A1&B1) and all I'm getting is a exactly
that..."=A1&B1"

And what I have is a datasheet with several thousand rows...how do I
make the operation apply to the entire columns?
 
Hi

Don't put brackets around the equation. Just
=A1&B1

Copy the formula and paste it down through the remaining cells in column
C.
The formula will later automatically as it is copied to each successive
cell e,g,
=A2&C2
=A3&C3

The easiest way to fill the cells going down is to use the fill handle.
Hover your cursor over the bottom left corner of cell C1 when you have
the formula correctly entered, and it will change to a small black
cross. Either double click the cursor at this point and it should fill
down, or, hold the left mouse button down as you drag down the column.
When you release the mouse button, the formula will be copied to the
range of cells marked.
 
OK, that's what I meant...I didn't put brackets in the cell...all I did
was enter into C1:

=A1&B1

And that's all that shows in the cell...do I just have a setting off or
something?
 
Hi

Your cell must have been formatted as Text.

Format>Cells>Number>General
Enter formula
Press Enter
 
Ah...

I've done this kind of thing before, I knew it was some stupid little
thing like that.
 
Hi

Its always the little things that catch us out. glad you got it sorted.
Thanks for letting us know.
 
Back
Top