| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
combine column data
Thanks!! These worked!
-- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200802/1 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combine data in two columns into one and sort the combined column alphabetically..how?? | Excel Discussion (Misc queries) | |||
| how to combine data from Column A & B | Excel Discussion (Misc queries) | |||
| How can I combine multiple columns of data into 1 column? | New Users to Excel | |||
| Combine the data in 2 columns of 20 rows into one column of 40 row | Excel Discussion (Misc queries) | |||
| How to combine data from two columns into one column? | Excel Worksheet Functions | |||
Linear Mode
