combine columns
 

I have two columns that I'd like to combine into a single column. For
example, I have two colums that similar to this:
A 4
B 5
C 6

I'd like to make these two individual columns become
A4
B5
C6

Thanks

Try this:

=A1&B1

And copy down as needed

--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

"RDB" wrote in message
...
I have two columns that I'd like to combine into a single column. For
example, I have two colums that similar to this:
A 4
B 5
C 6

I'd like to make these two individual columns become
A4
B5
C6

Thanks

Try this if you are working with text
=concatenate(A1,B1)

"RDB" wrote:

I have two columns that I'd like to combine into a single column. For
example, I have two colums that similar to this:
A 4
B 5
C 6

I'd like to make these two individual columns become
A4
B5
C6

Thanks

or

=A1 & B1

Cheers
JulieD

"Jason" wrote in message
...
Try this if you are working with text
=concatenate(A1,B1)

"RDB" wrote:

I have two columns that I'd like to combine into a single column. For
example, I have two colums that similar to this:
A 4
B 5
C 6

I'd like to make these two individual columns become
A4
B5
C6

Thanks