combine columns

[Guest]

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

 

[RagDyeR]

Try this:

=A1&B1

And copy down as needed

--

HTH,

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

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

 

[Guest]

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

 

[JulieD]

or

=A1 & B1

Cheers
JulieD

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