add zeros to fill in and
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.
|