"Dave Peterson" wrote:
=G5&" "&A7&" "&B7&" "&text(g7,"0000000000")&F7
&" "&F5

I think that should be:

=G5&" "&A7&" "&B7&" "&text(F7,"0000000000")
&" "&F5

Note that LG wants the result to be:

$PAAY3 ABC 20090810058 0000016833 LG

where 16833 comes from F7, not G7.

Likewise:

=G5&" "&A7&" "&B7&" "&text(F7,rept("0",10))
&rept(" ",23)&F5


----- original message -----

"Dave Peterson" wrote in message
...
You could use:

=G5&" "&A7&" "&B7&" "&text(g7,"0000000000")&F7&"
"&F5
or
=G5&" "&A7&" "&B7&" "&text(g7,rept("0",10)&F7&rept(" ",23)&F5

Ps. You don't need &""&

Using =rept() makes it easier to see things (for me anyway).



LG wrote:

Below is the information I have
cell G5 = $PAAY3
cell A7 = ABC
cell B7 = 20090810058
cell G7= 0000000000
cell F7= 16833
cell F5= LG

The top is the formula I have complete the bottom is what I need it to
show as
=G5&" "&A7&" "&B7&" "&G7&""&F7&" "&F5
$PAAY3 ABC 20090810058 0000016833 LG

I need to be able to get the zeros in G7 to fill in the #s from F7 in the
final product while deleting the zeros from G7 that is used can anyone
help.

--

Dave Peterson