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

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

--
Regards

Roger Govier


"dcnguyen"
wrote
in message
...

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


--
dcnguyen

------------------------------------------------------------------------
dcnguyen's Profile:
http://www.excelforum.com/member.php...o&userid=30251
View this thread:
http://www.excelforum.com/showthread...hreadid=499221



--
dcnguyen
------------------------------------------------------------------------
dcnguyen's Profile: http://www.excelforum.com/member.php...o&userid=30251
View this thread: http://www.excelforum.com/showthread...hreadid=499221