combine text from two columns to one

A

Andrea

I would like to combine text from Column A and Column B to appear as it would
in column C. My columns appear as follows:

A B
C

Bazooka BAZ12113
BazookaBAZ12113
JVC JVC23998
JVCJVC23998
Metra MTA23990
MetraMTA23990

.......and so on. I am not sure how to combine this text; excel seems to
want to apply some mathematical formula. My columns are up to several
thousand cells long in range. Is there any easy way to do this? There HAS to
be!! Please help!! :eek:
 
P

Pete_UK

Put this formula in C1:

=A1&B1

and then just copy it down. An easy way to do this is to select C1
once you've put the formula in, and then double-click the fill-handle
- this is the small black square in the bottom right corner of the
cursor. This will copy the formula down for as many contiguous data
items as you have in column B.

Hope this helps.

Pete
 
P

Per Jessen

Hi

To combine text in A1 and B1 use this:

=A1&B1

Then copy the formula down your range.

Hopes it helps.
 

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

Copy addition formula of non-consecutive horizontal cells 2
Combining three files when middle file has sections with endnotes 2
Help matching combined text cells 1
help with copying data from many columns into one long column 0
combining data from two columns into one 1
Finding the right style field in VBA 0
Development combinations with exclusion of columns 0
Combining Text From Cells 3

Top