EXCEL problem: all data mixed into one field ><

Discussion in 'Data Sets and Feeds' started by mfhboy, May 10, 2004.

  1. mfhboy


    I finally got the tick data I need but that's not arranged in a usable format and I can't get the data in another way...

    The problem is that all data are mixed into one field(Time, volume, price and type) when I copy and paste the data into EXCEL. How can I split the four items into 4 fields so I can apply further analysis with EXCEL. Here is the sample tick data.
  2. mfhboy


    I've found the solution from another EXCEL forum

    Select Data > Text to Columns
    Choose Delimited as your file type and Click on next
    Choose Space as your delimiter
    Choose the appropriate Column Data Format , if applicable
    Click on Finish