[johni]

Hi anyone knows how to save the following into different delimit?

When save in excel as .txt the following is :

02/05/08 9:59 7.975 7.985 7.97 7.975
02/05/08 10:00 7.975 7.975 7.965 7.97
02/05/08 10:01 7.975 7.985 7.965 7.985
02/05/08 10:02 7.975 7.975 7.97 7.97
02/05/08 10:03 7.97 7.97 7.96 7.96

Wanted to save in as the follow :

02/05/08,9:59,7.975,7.985,7.97, 7.975
02/05/08,10:00,7.975,7.975,7.96 5,7.97
02/05/08,10:01,7.975,7.985,7.96 5,7.985
02/05/08,10:02,7.975,7.975,7.97 7.97
02/05/08,10:03,7.97,7.97,7.96,7 .96

A utlitiy specificing the options like data format, delimited used, etc would be good.

Or save the above using excel but excel always has tab when saved in text.