combine column data
 

I would like to take to column named 'strength' and 'strUnit' and combine the
values. When I select both columns and click merge both columns disappear. I
thought there might be a formula to combine the strings. Will you help me?
Misty

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200802/1

combine column data
 

use &

For example

-------A--------B-------C
1--Michael---Jordan---=A1&" "&B1

Using the formula A1&" "&B1
would make C1 say Michael Jordan


"Mitchell_Collen via OfficeKB.com" wrote:

I would like to take to column named 'strength' and 'strUnit' and combine the
values. When I select both columns and click merge both columns disappear. I
thought there might be a formula to combine the strings. Will you help me?
Misty

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200802/1

combine column data
 

=a1&b1
or
=a1&" "&b1

Adjust the cells to the addresses for the first cell in each of those columns.

Then drag the formula down as far as you need.

"Mitchell_Collen via OfficeKB.com" wrote:

I would like to take to column named 'strength' and 'strUnit' and combine the
values. When I select both columns and click merge both columns disappear. I
thought there might be a formula to combine the strings. Will you help me?
Misty

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200802/1

--

Dave Peterson

combine column data
 

Thanks!! These worked!

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200802/1