Thanks JoeU2004 this was exactly what I need... I really appreciate you time

"JoeU2004" wrote:

[Sorry about the previous "empty" response. Pushed the wrong button.]

"LG" wrote:
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.

Do you really need G7 at all? Does this meet your needs:

=G5&" "&A7&" "&B7&" "&REPT("0",MAX(0,10-LEN(F7)))&F7&"
"&F5

For that matter:

=G5&" "&A7&" "&B7&" "&REPT("0",MAX(0,10-LEN(F7)))&F7&REPT(" ",24)&F5


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

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