EXCEL problem: all data mixed into one field ><

M

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.
 

Attachments

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
 
You must log in or register to reply here.
Back
Top