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

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

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