delimited question

[Guest]

I generated some raw data and want to delimit it out. Unfortunately, when the
data was created, little boxes appeared in front of them. I can manually
delete them, but there are over 10,000 records. Here is an example of the
data:

" 3598297 A 12/27/05 12/31/05 DISCHG 19,708.00
.00 19,708.00 4"
" 3598327 A 12/27/05 0/00/00 INHOUSE 28,929.00
50.00 28,879.00 5"
" 3591800 A 12/14/05 0/00/00 INHOUSE 12,682.00
.00 12,682.00 18"

Can you help me.
Thank you

 

[John Bundy]

I don't see "little boxes" but you can try =Trim(A1)

 

[Guest]

Metaotechs,
If you import the data as xml, don't use delimited. Set up the breaks
yourself, the little boxes might show up but will not print.

anitadai