Hello there,

I am trying to apply a specific format and unfortunately not having luck --
HELP -- this is driving me nuts!

I tried to apply w/ a custom format and it doesn't work. How do you create a
custom format that has both zeroes and alpha characters that applies into the
same field. I need to create this for a custom import into another program.

This is what I am trying to do below:

Currently this is how it shows:

5BC 012345 67890 HEALTH 01-00-123459-00 << 1 space in between each area


5BC 012345 67890 HEALTH 01-00-123459-00 < There needs to be 3 spaces
applied after the 5BC, 1 space after the 012345, 3 spaces after the 67890,
and 2 spaces after the HEALTH.

Any suggestions to make this work the way I need it to to apply to whatever
field I choose this format and apply it to the fields without manually going
through over 330 lines of info that is similar but w/ different gl #'s and or
account #'s?

Any suggestions or how to's would be a beautiful thing!!