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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

dcnguyen - 08 Jan 2006 23:03 GMT

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).

Signature

dcnguyen

Reply to this Message

Roger Govier - 08 Jan 2006 23:13 GMT

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

Signature

Regards

Roger Govier

> 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).

Reply to this Message

dcnguyen - 08 Jan 2006 23:29 GMT

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?

Roger Govier Wrote:

> Hi
>
[quoted text clipped - 30 lines]
> > View this thread:
> > http://www.excelforum.com/showthread.php?threadid=499221

Signature

dcnguyen

Reply to this Message

Roger Govier - 08 Jan 2006 23:41 GMT

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.

Signature

Regards

Roger Govier

> Thanks for the response...two things...
>
[quoted text clipped - 39 lines]
>> > View this thread:
>> > http://www.excelforum.com/showthread.php?threadid=499221

Reply to this Message

dcnguyen - 08 Jan 2006 23:52 GMT

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?

Signature

dcnguyen

Reply to this Message

Roger Govier - 08 Jan 2006 23:58 GMT

Hi

Your cell must have been formatted as Text.

Format>Cells>Number>General
Enter formula
Press Enter

Signature

Regards

Roger Govier

> OK, that's what I meant...I didn't put brackets in the cell...all I
> did
[quoted text clipped - 5 lines]
> or
> something?

Reply to this Message

dcnguyen - 09 Jan 2006 00:22 GMT

Ah...

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

Signature

dcnguyen

Reply to this Message

Roger Govier - 09 Jan 2006 00:28 GMT

Hi

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

Signature

Regards

Roger Govier

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

Reply to this Message