I'm confused by your examples, but does this help?

A1 contains
80790-000-000

B1 contains
200

C1 contains
2252

You need to concatenate the 3 cells, with the stipulation that the first
value contains 19 characters, the second contains 12 characters, and the
third contains 6.

Try this in D1:

=A1&REPT(" ",19-LEN(A1))&B1&REPT(" ",12-LEN(B1))&C1&REPT(" ",6-LEN(C1))

Now, to remove the formula from D1, and leave behind only the data with the
appropriate spaces,
Right click in D1 and choose "Copy".
Right click again and choose "Paste Special".
Click on "Values", then <OK, then <Esc.

You should now have D1 ready to copy and paste to your accounting software.

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

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