| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do i merge two collums together?
I have two columns with different info in each. I would like to combine the
entire column to make one. I noticed that in the help section, it allows me to do this by cell, but i have 924 cells so I would prefer to do this by columns. Thanks! joy |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do i merge two collums together?
use the =concatenate() function in a 3rd column, to copy and paste 924 cells
should take all of 10 seconds... "Joy Bell" wrote: I have two columns with different info in each. I would like to combine the entire column to make one. I noticed that in the help section, it allows me to do this by cell, but i have 924 cells so I would prefer to do this by columns. Thanks! joy |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do i merge two collums together?
what do you mean by merge in this case?
do you want to have all of the information from the column in one cell? do you want to have a third column with the combined text for each row from the two columns to you want to sum numerically? Depending on what you want, there are many different answers to your question. "Joy Bell" wrote: I have two columns with different info in each. I would like to combine the entire column to make one. I noticed that in the help section, it allows me to do this by cell, but i have 924 cells so I would prefer to do this by columns. Thanks! joy |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| mail merge excludes my headers and critical data in Word merge | Excel Discussion (Misc queries) | |||
| Merge =( formula should retain fraction type numbers after merge. | Excel Worksheet Functions | |||
| how do i get my mail merge to update the data source at each merge | Excel Discussion (Misc queries) | |||
| matches in two collums of numbers? | Excel Discussion (Misc queries) | |||
| Adding data on Axis Major Gridlines next to Category Axis Collums | New Users to Excel | |||
Linear Mode
