|
PureBytes Links
Trading Reference Links
|
Ken,
Have you tried using the Text Import Wizard in Excel and setting the
delimiters as space and/or tab? I think that should work.
Denis
"iamken@xxxxxxxxxxxxxxx" wrote:
> Hi,
>
> I have a boatload of non comma separated ASCII data that I need to
> convert into Metastock format, but I don't know how to get commas
> between the fields. My feeble attempts to do this in Excel have failed,
> but I think there must be a painless way to do this? Any help would be
> appreciated.
>
> Here's a sample of what I am working with.
>
> 19971201 925 118.71875 118.71875 118.71875 118.71875 2
> 19971201 951 118.71875 118.71875 118.71875 118.71875 1
> 19971201 954 118.78125 118.78125 118.78125 118.78125 1
>
> Thanks!
> Ken
|