| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I merge data in several columns in Excel or Access?
In Access I have a large database with 7000+ records. I want to combine the
data in 6 columns in this. I could not find a way to do it in Access so copied it to Excel. I can apparently merge cells in Excel (and using CHAR(10) between fields which will make things very neat) but it does not tell me how to merge complete columns in one go. I am using Vista Home Premium and Office 2007. Can anybody please tell me - step by step - how I can do this? Assuming it is possible. Many thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| mail merge excel from access data | Excel Discussion (Misc queries) | |||
| How do I merge 2 columns of numerical data? | Excel Discussion (Misc queries) | |||
| VLookup to merge Access Query data into Excel Report | Excel Discussion (Misc queries) | |||
| There should be a mail merge feature between excel and access. | Excel Discussion (Misc queries) | |||
| How to merge rows of data in 2 columns into 1 col. | New Users to Excel | |||
Threaded Mode
