• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

merging selected fields in a csv file to a worksheet

D

dluizalee

New Member
I need to merge all records, but only specific columns of each record, into an excel worksheet. The csv file is comma delimited. The number of records in the csv file will vary. What is the best way to do it?
 
Good day dluizalee


Welcome to the forum, it will help in the future if you read the green stickys.


As to your question try this,


In the Data tab choose import from text file, as you go through the options you will be able to select columns and choose whether to import or not.
 
Hi dluizalee,


Welcome to the forum, take a look at this previous post on a similar question, it may help?


http://chandoo.org/forums/topic/combine-data-from-columns-into-single-cell


If it doesn't please post back here. Also please read (if you haven't already) the green stick on New Users


http://chandoo.org/forums/topic/phd-forum-posting-rules-etiquette-pls-read-before-posting
 
You must log in or register to reply here.
Back
Top