+ Reply to Thread
Results 1 to 6 of 6

Problem to separate csv file data into two columns

Hybrid View

  1. 09-19-2014, 08:11 PM #1
    mehmetcik
    mehmetcik is offline
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Problem to separate csv file data into two columns

    have you tried using the text to columns function in the data tab?

    Select your data column

    click on text to columns

    make sure delimited is selected and press next

    select comma as your delimiter and press next

    press finish
    Last edited by mehmetcik; 09-19-2014 at 08:15 PM.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Problem to separate in two different groups or columns with criteria
    By wichiu1 in forum Excel General
    Replies: 8
    Last Post: 01-09-2014, 10:02 AM
  2. Problem saving Excel file that copies an embedded object from a separate file
    By bhodge10 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-16-2012, 02:47 PM
  3. Separate csv file by columns
    By goldcoast in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-11-2012, 07:08 PM
  4. Excel 2007 : How to import few fields of data from Master file to separate excel file
    By Sonal Parkar in forum Excel General
    Replies: 0
    Last Post: 08-10-2010, 07:00 AM
  5. Problem running macro that saves into a separate file (2007 issue only)
    By mikeenc in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-17-2009, 10:45 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1