Seperating values that are space-separated in one cell to several cells

Hey,
I have a .txt file, that is the output of a vb 6 code. It is supposed to have seven columns in each row. The seven values in each row exist, but they are in one cell, and are space-separated. This way I can't do any other calculations with the numbers. I need it to have seven columns in seven separate cells in each row. I'm not sure whether posting this question in macro forum is right or not. Anyway the file is attached. Thank you for your helps.

Hi Ferferi,

This would be best placed in the formula/functions forum. Maybe one of he mods will move it for you?!

Open the text file with excel, excel will prompt you to use the text to columns function. Select delimited and then select spaces, click finish. This will your data and break it into cells every time a space is detected.

Otherwise paste the data into excel, highlight the data. Select Data then select Text to column and follow the instruction as above.

Hope this helps.

It worked perfectly. Thank you Break_Point.
I really don't know how to change the forum. I thinks mods know what to do.

الان این آخرین جمله ای که نوشتی رو خودت ترجمه کن فرخ

یعنی فکر می کنم که مدیران اینجا خودشون درستش می کنن.