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. |
All times are GMT +1. The time now is 02:27 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com