=a2&b2

copy it down
--

hth
regards from Brazil
May the force be with you
Marcelo
*******************


" escreveu:

I have two columns of data (A and B) that are already filled up with
data. (Column A is text data and column B is numeric data). Can I
create a new column (Column C) that globally concatenates values in the
same row in Column A and B into C?

eg my data looks like this

column a column b column c

AAA 111 AAA111
AAA 222 AAA222
AAA 333

Is there a way I can do this without using the concatenate function in
each individual cell in Column C? Ie. do a global concatenate for
column C.

Thank you in advance