I would like to copy and paste data from Excel into our accounting software
for journal entries. However, I've found that it must equal a specific amount
of spaces in order for it to work. I'd like to create a worksheet for others
to turn in and have a separate tab that will put it in a pastable format. For
instance, the first three fields have the following spaces available: 19, 12
and 6, yet the data to be pasted will most likely be less than that. An
example that works is:

80790-000-000______._____20000-._2252 [period represents the beginning of
the next field and also counts as a space]

The data provided from others would be...
GL: 80790-000-000
Amount: (200.00) [the negative sign goes afterwards and no decimal point is
used]
Job No.: 2252

In the example above, the _ represents spaces that must be put in place in
order for the pasting to line up in the proper fields. Any ideas on how this
could be done? The trick is that not all the required data will be the same.
Amounts will always change and the GL could be just 80790 or 80790-010. If I
could have a formula that counts how many digits are in a cell, then
automatically place spaces to fill up the remaining amount, I believe it
would work.

Thanks for any help.

Corey