Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel Programming

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 09-27-2017, 03:41 PM
Alex99 Alex99 is offline Windows 7 64bit Office 2007
Novice
 
Join Date: Sep 2017
Posts: 1
Alex99 is on a distinguished road
Default Merging multiple CSV files into a new EXCEL workbook

Help needed!!



I have a bunch of individual CSV files and I would need to merge the third column of each CSV file into a new workbook. For example, the third column of the first CSV file goes into the first column of the new EXCEL file, the third column of the second CSV file goes into the second column of the new EXCEL file and so on.

Thanks!
Reply With Quote
  #2  
Old 09-30-2017, 01:54 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Windows 7 64bit Office 2010 64bit
Moderator
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 1,901
Pecoflyer is just really nicePecoflyer is just really nicePecoflyer is just really nicePecoflyer is just really nicePecoflyer is just really nice
Default

Hi and welcome
Have a look at this addin by Ron de Bruin

It's safe, and using the " paste data next to each other " option will do what you need
Reply With Quote
Reply
Please reply to this thread with any new information or opinions.

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Merging Multiple Files by Name, Date abs004 Excel 1 03-02-2017 04:21 PM
Merging multiple fields within a Word letter from Excel LindsayV Mail Merge 2 04-08-2016 07:17 AM
Word does not put the files in the outbox of Outlook (merging with excel fields) Pannemanski Mail Merge 1 04-08-2016 03:58 AM
Merging word files from excel macro hklein Excel Programming 0 08-05-2011 02:27 AM
Merging Multiple Word files into One Stattovic Word 2 01-15-2010 10:16 AM


All times are GMT -7. The time now is 06:21 PM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft