| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
how do i combine the contents in a colum to the conten next to it
im trying to merge an entire column into the column next to it. and keep the
same rows |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
how do i combine the contents in a colum to the conten next to it
Method 1
=A1&B1&C1 If you want to add some more cells then add & symbol and mention the cell name. Method 2 =CONCATENATE(A1,B1,C1) If you want to give space between the cell values then construct your formula like this. =CONCATENATE(A1," ",B1," ",C1) =A1&" "&B1&" "&C1 Remember to Click Yes, if this post helps! -------------------- (Ms-Exl-Learner) -------------------- "gin" wrote: im trying to merge an entire column into the column next to it. and keep the same rows |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I combine column A into Colum B? | Excel Discussion (Misc queries) | |||
| How do I combine the contents of two columns? | Excel Worksheet Functions | |||
| How can I combine cell contents? | Excel Discussion (Misc queries) | |||
| I am trying to combine contents from 2 cells into 1 | Excel Worksheet Functions | |||
| Can I combine column A into Colum B? | Excel Discussion (Misc queries) | |||
![gin[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
