ncgloryholes
welcome to my space
Home

excel opens csv data in a single column

January 7th, 2009 by admin
  • hi .
    i m working with excel 2000.
    when i open text file with separated value like : lll ooo ppp
    excel recognize separated value and ask me how to show the file.
    this is ok.
    BUT
    when i try to open csv file or text file with , separated value : iii,ppp,kk
    excel dows NOT recognize separated value and open it ,without asking me,
    in single column .


  • Hi
    I Try To Open Text File!!! Like : Lll , Llp ,lll
    And Excel Does Not Recognize Separated Values Not
    Just Csv Files !!!


  • You have to tell Excel its delimited by comma when you open the text file.


  • Text File : Ppp,rrr Excel Recognize Separated Value
    Text File : Ppp,3256 ,oop Excel Does Not Recognize


  • hi
    i dont understand how to tell excel about the text file
    that it is separate by comma ?
    do i must do this only by import data ?
    does excel 2000 not configure correctly
    about comma separated value ?


  • Try opening Excel and then do File - Open - change type to text and it should give you an option to select the column boundaries. If this not work change file from xxx.csv to xxx.txt and then Excel should operate as normal.







    • #If you have any other info about this subject , Please add it free.#
    Your name:
    E-mail:
    Telphone:

    Your comments:


    If you have any other info about excel opens csv data in a single column , Please add it free.

    Posted in ncgloryholes.com | edit

    Cycling Idol Faced With More Doping Allegations Los Angeles, Ca - Home and Garden


    Categories


    Archives


    Blogroll



    Meta