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

"John Bundy" wrote:

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

--
--
-John
Please rate when your question is answered to help us and others know what
is helpful.

"metaltecks" wrote in message
...
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