Concatenating entire columns

  • Thread starter Thread starter c_sicker
  • Start date Start date
C

c_sicker

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
 
In C1 enter:

=A1&B1

Click back in C1 to select it, then *double* click on the "fill handle"
(small square in the lower right corner if the selected cell) to
automatically copy it down Column C, as far as there is data in Column B.

If you wish to remove the formulas, and leave just the data behind, while
the column is *still* selected from the copy, right click in the selection
and choose "Copy".
Then right click again in the selection and choose "Paste Special".
Click on "Values", then <OK>, then <Esc>.
 
=a2&b2

copy it down
--

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


"(e-mail address removed)" escreveu:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Compare cells in different worksheets 3
Excel Concatenate with line breaks but ignore blank cells 3
Vlookup using concatenated column indexes 7
VLOOKUP and return formula 1
vlook up and return formula 3
Concatenate If 4
IF Function and Concatenation 8
combining columns and using concatenate 5

Back
Top