Open excel
File|open
point at your .dat file.
On the first step of the text import wizard, you'll see two options--delimited
and fixed width.

Choose delimited.

Follow the rest of the wizard to import your file.

Morefeus Direct wrote:

hi dave, on this file you said open it and select delimited now were can i
find this opption , can you be a bit more spacific with your directions with
me i'm new at this.

thanks
MJohnson

"Dave Peterson" wrote:

Open it (select delimited, other and use the caret).

Save it as a new name *.csv.



Morefeus Direct wrote:

is there a way to convert a ^ (shift +6 ) delimited.dat file to a csv file?????
is this possible
"Pete" wrote:

I don't think there is a limit - if Excel sees that a column is empty
then it won't try to export it. Try putting a single space in Q1, R1
and S1 (or a heading) and see if that cures it.

Pete



--

Dave Peterson


--

Dave Peterson