Problem to separate csv file data into two columns

[High ground]

I have a csv file that contains only two types of data - a date, then a separating coma, then a decimal number, then separating rectangular symbol, then the next date and so on. There are over a thousand days involved.

The data reads continuously and a small cut sample is ....
2014-09-10,0.010200
2014-09-09,-0.077500
2014-09-08,-0.020800
2014-09-07,0.000000
2014-09-06,0.000000
2014-09-05,-0.158400
2014-09-04,-0.149800

I don't know why the rectangular symbols that follow each decimal number do not appear on the paste.

I want to have the dates in a column, then the decimal numbers in an adjacent column, and then another four or more blank columns for me to calculate weekly, monthly and yearly returns as the decimal numbers represent daily return on my investment, which is going badly.

I would appreciate any help or advice as I'm only a novice user, but willing to learn.

[mehmetcik]

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

[FDibbins]

Hi, welcome to the forum

While the suggested text-to-Columns should break your data into 2 columns, and give you the dates and decimals you want, and formula alternative would be...

=DATEVALUE(LEFT(A1,10))
and
=--MID(A1,12,8)

[High ground]

Thankyou Mehmetcik and Ford, the information and advice was just what I was looking for.
regards,
James

[FDibbins]

Happy to help

[cplmckenzie]

High ground,

Try the attached sheet with you sample data from your original post.
It seems to work based on the two responses you were given.

cplmckenzie