yes it is always like that, the only reason I have to do this, is that if the line meets certain crytea, I have it sent to another file, and then that file I am inporting into excel. Excel need's a day to determine the difference between the name, and the numbers right next to the name. I need to figure out a way to just have everything line up, right now my output file is looking like this:

LASTNAME FIRSTNAME MANNUMBER SKILL_LEVEL STATUS DUEBY HOWLONG
APODACA AMBER L 04549 005 *AWACT 27 JAN 05 3MONTHS
ARMSTRONG EARL II 05579 005 *AWACT 27 JAN 05 3MONTHS
ARNETT CHARLES D 05738 005 *AWACT 22 JAN 05 3MONTHS
AYALA RENE 05877 005 *AWACT 23 JAN 05 3MONTHS

and I need it like Ayala Rene 05877 005 *AWACT 23 JAN 05 3 MONTHS
ARNETT CHARLES ETC with a large space inbetween each field so excel can understand it's suppose to be inserted into a different cell.

LOL, guess this form doesn't undestand putting differen twords with large spaces inbetween. I just need each field to have like a TAB worth of space inbetween each one.

Last edited by Bordom; 14/11/04 12:31 AM.