How to Combine columns in Microsoft Excel
1. Create a blank column in Excel.2. Paste the following into the column's first cell:
=CONCATENATE(H1," ",I1," ",J1)
3. Change the column numbers to match the ones you want to combine.
4. Use the copy cell function to drag the contents of the first cell down through the rest of the cells in the column.
5. Save the Excel file as a CSV and you are finished.
Related Articles
- List Won't Import (ListMaker Pro)
- Combining Lists with ListMaker Pro
- Searching and Exporting Data in SPD ListMaker Pro
- Searching, Exporting and Combining Lists in ListMaker (Access Version)
- Importing a national DNC file ListMaker for SPD (Access Version)
Attachments
No attachments were found.Visitor Comments
No visitor comments posted. Post a commentPost Comment for "How to Combine columns in Microsoft Excel"
To post a comment for this article, simply complete the form below. Fields marked with an asterisk are required.Article Details
Last Updated
25th of August, 2008
